Gary is the Microsoft Project Server administrator for his company, and is configuring a restore method for his SQL Server. Gary would like to use a command to ensure that the backup operation verifies each page for checksum and torn page and for the entire backup. What command should Gary use?
A.
STOP_ON_ERROR
B.
NO_CHECKSUM
C.
CHECKSUM
D.
CONTINUE_AFTER_ERROR
Explanation:
The CHECKSUM command requests that the backup operation verify each page for checksum and torn page.
Answer option B is incorrect. The NO_CHECKSUM is the default selection for the restore, and does not verify each page during the restore process. Answer option D is incorrect. CONTINUE_AFTER_ERROR is used in conjunction with the CHECKSUM command. When an error occurs, this command allows the restore to continue but logs the error.
Answer option A is incorrect. STOP_ON_ERROR is used in conjunction with the CHECKSUM command. When an error occurs, this command stops the restore process.