PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are moving a SQL Server 2005 database named Timesheet to a new database server. The Timesheet database is used by the TimeEntry application. You need to minimize the amount of time that the TimeEntry application is unavailable while you move the database. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Move the database to the new server by using the SQL Management Object method in the Copy Database Wizard.

B.
Detach the current database. Copy the data files to the new server. Attach the files.

C.
Back up the database. Copy the backup file to the new server. Restore the database.

D.
Move the data files. Specify the new location by using ALTER DATABASE.


Leave a Reply