You work as a database administrator at Domain.com. Domain.com is using SQL Server 2008
Enterprise Edition. Domain.com contains a database that unfortunately has torn page errors.
You need to solve the problem of the torn page errors.
What should you do?
A.
You should consider restoring the database from the latest snapshot of the database.
B.
You should consider restoring the latest database backup and then restore the transaction logs
which have been made since the latest backup.
C.
You should consider using DBCC CHECKDB.
D.
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.