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?
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.