You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008
R2 instance.
You monitor the transaction log of the instance on a daily basis. On this particular day you are
presented with information regarding torn page errors in the database.
You have been instructed to rectify these errors as soon as possible.
Which of the following actions should you take? (Choose two.)
A.
You should consider restoring only the torn pages from the most recent full database backup.
B.
You should consider restoring the full database from the most recent full database backup.
C.
You should consider restoring the most recent snapshot backups.
D.
You should consider restoring the transaction logs that was created since the full backup.
Explanation: