You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include administrating a SQL Server 2005 database named CK_Timesheet. You have received instruction from the CIO to move CK_Timesheet to a new database server. At present the CK_Timesheet database is used by the CK_TimeEntry application. You need to minimize the amount of time that the CK_TimeEntry application is unavailable while she moves the database.
What should you do?
A.
You should back up the database and copy it to the new server. Then the database can be restored.
B.
You should move the database to the new server by using the SQL Management Object method in order to accomplish this. This method is located in the Copy Database Wizard.
C.
You should move the data files and identify the new location by using ALTER DATABASE in order to accomplish this.
D.
You should detach the current database. Thereafter you can copy the data files to the new server and attach the files.
Explanation:
You can unmount databases from a SQL Server by detaching them. This process removes the entries in the system tables for this database. This causes 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. Every operation requires only 1-2 seconds at most to complete.