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…

The correct answer is C. CHECKSUM. The CHECKSUM command requests that the backup operation verify each page for checksum and 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…

Administering Project Server 2010

Question

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?

Options

ASTOP_ON_ERROR
BNO_CHECKSUM
CCHECKSUM
DCONTINUE_AFTER_ERROR

How the community answered

(33 responses)

A
15% (5)
B
3% (1)
C
73% (24)
D
9% (3)

Explanation

The CHECKSUM command requests that the backup operation verify each page for checksum and 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 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.

Topics

#SQL Server backup#CHECKSUM#backup verification#database administration

Community Discussion

No community discussion yet for this question.

Full 70-177 Practice