Microsoft
70-432 · Question #130
You are mastering the company database, you should check the log of the SQL Server 2008 Enterprise Edition everyday, and you get the information on the torn page errors of the database. In order to…
The correct answer is A. You backup to restore only the torn page. Then restore any transaction logs which have been. See the full explanation below for the reasoning.
Question
You are mastering the company database, you should check the log of the SQL Server 2008 Enterprise Edition everyday, and you get the information on the torn page errors of the database. In order to fine the solution of the torn page, which is the correct answer?
Options
- AYou backup to restore only the torn page. Then restore any transaction logs which have been
- BYou should reserve the newest database backup and then reserve any transaction logs which
- CYou should operate DBCC CHECKDB.
- DYou should reserve the database from the newest database snapshot.
How the community answered
(22 responses)- A77% (17)
- B14% (3)
- C5% (1)
- D5% (1)
Community Discussion
No community discussion yet for this question.