PrepAway - Latest Free Exam Questions & Answers

What steps should you take?

You work as a database administrator at ABC.com. ABC.com is using SQL Server 2008
Enterprise Edition. ABC.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)

PrepAway - Latest Free Exam Questions & Answers

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.

Explanation:


Leave a Reply