Microsoft Exam Questions

If you are required to move an SQL 2012 dat…

If you are required to move an SQL 2012 dat

abase 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 Wi

zard 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.

References: