You work as a database administrator at TestKing.com. TestKing.com is using SQL Server
2008 Enterprise Edition. TestKing.com contains a database that unfortunately has torn page
errors. You need to solve the problem of the torn page errors.
What steps should you take? (Each correct option is part of the answer. Choose TWO)
A.
By using the newest database backup to restore the full database.
B.
By using the newest database backup to restore only the torn page.
C.
By restoring the database from the latest snapshot of the database.
D.
By restoring the latest database backup and then restore the transaction logs which have been made since the latest backup.
E.
By using DBCC CHECKDB.
F.
By restoring any transaction logs created since the latest full backup.