You work as a database administrator at Domain.com. Domain.com is using SQL Server 2005
Enterprise Edition. You need to get the information on the torn page errors of the database.
However, you need to get a solution on the torn page errors.
What should you do?
A.
You should consider restoring the latest database backup and then restore the transaction logs
which have been made since the latest backup.
B.
You should consider using the newest database backup to restore only the torn page.
Thereafter you should restore any transaction logs which have been made since the latest full backup.
C.
You should consider using DBCC CHECKDB.
D.
You should consider restoring the database from the latest snapshot of the database.