You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. A full backup of your database named CK_Data is created automatically at midnight every day. You have been informed by the CIO that differential backups of CK_Data occur twice a day at 10:00 and at 16:00. A database snapshot is thus created daily at noon. A Domain.com user named Dean Austin is appointed as the technician in the Research and Development department. The CIO informs you that a developer accidentally dropped the NewProjects table in CK_Data at 12:30. You check and notice that the NewProjects was last updated one week ago. You instruct Dean Austin to recover the NewProjects table. He needs to accomplish this by using the minimum amount of administrative effort. It is important that he reduces the amount of information that is lost.
What should he do?
A.
All database snapshots need to be deleted except the latest one. Thereafter CK_Data can be restored from the latest database snapshot.
B.
It is important that Dean Austin restores the latest backup into a new database named CK_Data_Temp. The latest differential backup can then be applied. Thereafter the NewProjects table from CK_Data_Temp should be copied to CK_Data.
C.
Dean Austin should copy the NewProjects table from the latest database snapshot into CK_Data.
D.
From the latest backup Dean Austin can recover the CK_Data and apply the latest differential backup on it.
Explanation:
SQL Server 2005 introduces the capacity for administrators to generate and use a read-only, stable view of a database. The database snapshot offers this capability without the overhead of creating a complete copy of the database or storage requirement. As the primary database diverges from the snapshot, the snapshot gets its own copy of original pages when they are modified. The snapshot may be used to recover an accidental change to a database by simply reapplying the pages from the snapshot to the primary database. As the last snapshot was created at noon the same day that the Pricelist table was dropped and the fact that there has been no changes to the table makes it possible to just copy the table from the snapshot.