Microsoft
70-432 · Question #152
You are mastering the company database, You should check the log of the a SQL Server 2005 Enterprise Edition everyday, You get the information on the torn page errors of the database. In order to…
The correct answer is A. You should utilize the latest database backup to restore only the torn page. See the full explanation below for the reasoning.
Question
You are mastering the company database, You should check the log of the a SQL Server 2005 Enterprise Edition everyday, 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 should utilize the latest database backup to restore only the torn page.
- BYou should reserve the newest database backup and then reserve any transaction logs
- CYou should operate DBCC CHECKDB.
- DYou should reserve the database from the newest database snapshot.
How the community answered
(34 responses)- A76% (26)
- B6% (2)
- C3% (1)
- D15% (5)
Community Discussion
No community discussion yet for this question.