PrepAway - Latest Free Exam Questions & Answers

You need to migrate your existing databases to the new server

You want to upgrade the server that runs Microsoft SQL Server 2005 in your Microsoft Office Project Server 2007 environment. You install a new server. You need to migrate your existing databases to the new server. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Perform a backup of the databases on the old server. Restore the databases to the new server.

B.
Create new databases on the new server that have the same names as on the old server. Copy the .mdf files from the old server to the new server.

C.
Create new databases on the new server that have the same names as on the old server. Copy the transaction logs from the old server to the new server.

D.
In the SQL Server settings on the old server, set the database default locations to folders on the new server.


Leave a Reply