You are a database administrator for AIOTestKing.com. You review the error log for a SQL Server 2005 Enterprise Edition computer. You notice torn page errors for one database.
You need to resolve the torn page problem as quickly as possible. What should you do?
A.
Use the latest database backup to restore only the torn page. Then restore any transaction logs that have been made since the full backup.
B.
Run DBCC CHECKDB.
C.
Restore the latest full database backup and then restore any transaction logs that have been made since the full backup.
D.
Restore the database from the most recent database snapshot.