Which of the following will do this at the database level?

If you are required to move an SQL 2012 database from one server to another, which of the following will do this at the database level?
A. You just have to mirror the database.
B. Detach the database, move the database files, and attach the database on the new server.
C. Use the SQL Server Move Wizard to define the old and new server as well as the scheduled move time.
D. The database must be created on the new machine and then the data moved with Export/Import.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.