You are mastering the company database, You should check the log of the a SQL Server
2005 Enterprise Edition everyday, You get the information on the torn page errors of the
database. In order to fine the solution of the torn page, Which is the correct answer?
A.
You should utilize the latest database backup to restore only the torn page. Then restore
any transaction logs which have been made since the full backup.
B.
You should reserve the newest database backup and then reserve any transaction logs
which have been made since the past backup.
C.
You should operate DBCC CHECKDB.
D.
You should reserve the database from the newest database snapshot.