Microsoft
70-432 · Question #143
You are managing your company database. You manage a SQL Server 2005 database called ContractTEST, which is down. You operate a restore by using the following Transact-SQL script. RESTORE DATABASE…
The correct answer is C. You should add code. See the full explanation below for the reasoning.
Question
You are managing your company database. You manage a SQL Server 2005 database called ContractTEST, which is down. You operate a restore by using the following Transact-SQL script. RESTORE DATABASE ContractTESTFROM contracts_bu_deviceWITH CONTINUE_AFTER_ERROR, CHECKSUM, RECOVERY After the restore, the SQL Server logs show errors in some page restores. What you should do is to repair the database pages, which are down, and facilitates repair by using the fastest method. Which is the correct answer?
Options
- AYou should add code:
- BYou should add code:
- CYou should add code:
- DYou should add code:
How the community answered
(25 responses)- A4% (1)
- B16% (4)
- C76% (19)
- D4% (1)
Community Discussion
No community discussion yet for this question.