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 statement to restore the full database backup that comes before the differential backup to restore your SQL database?
A.
NORECOVERY
B.
RESTORE
C.
RECOVERY
D.
RESTORE_DIFF
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 logs to follow.
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.