70-177 · Question #78
You are the Microsoft Project Server administrator for your organization and you need to perform a restore to the PSGHT SQL database. You have been using the differential model so you will need to res
The correct answer is A. NORECOVERY. When you are recovering a fault using a differential database backup, you will first restore from the full backup the differential is based on and you will use the clause NORECOVERY. This signals to the restore that this is the full backup and additional transaction logs backups
Question
You are the Microsoft Project Server administrator for your organization and you need to perform a restore to the PSGHT SQL database. You have been using the differential model so you will need to restore from multiple media. What clause will you need to include in your RESTORE DATABASE tatement to restore the full database backup that comes before the differential backup to restore your SQL database?
Options
- ANORECOVERY
- BRESTORE
- CRECOVERY
- DRESTORE_DIFF
How the community answered
(38 responses)- A82% (31)
- B11% (4)
- C3% (1)
- D5% (2)
Explanation
When you are recovering a fault using a differential database backup, you will first restore from the full backup the differential is based on and you will use the clause NORECOVERY. This signals to the restore that this is the full backup and additional transaction logs backups are to follow. Answer option C is incorrect. RECOVERY is used when there are no additional transaction Answer option D is incorrect. RESTORE_DIFF is not a valid SQL command. Answer option B is incorrect. RESTORE is the command that is used with the NORECOVERY or RECOVERY clause.
Topics
Community Discussion
No community discussion yet for this question.