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?
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.
Explanation:
You can unmount databases from a SQL Server by detaching them.
This process removes the entries in the system tables for this database, causing it to no longer be accessible on the SQL Server instance. Although the database is inaccessible, the files that contain all the objects and data still exist on the operating system in the location in which you created them. After they are detached, you can copy these files to any location on your network because they are no longer being accessed by SQL Server. The detach operation requires SQL Server only to close the files and remove an entry in the system tables. And an attach requires SQL Server to simply open the files and make an entry in the system tables. Each operation requires only 1-2 seconds at most to complete.