You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. Every Sunday, AIOTestKing A executes a job that performs a full backup of a database named HR. Each weeknight, AIOTestKing A executes a job that performs differential backups. All jobs have the option enabled to verify data in the backup. The HR database is often not able to be restored after a failure, because of errors with the data stored on the tape. You need to design a restore process that ensures that as much data as possible is restored, even when errors occur. What should you do?
A.
Create a database restore process by using Transact-SQL. Include the CONTINUE_AFTER_ERROR option.
B.
Create a database restore process by using SQL Distributed Management Objects (SQL-DMO). Set the ReplaceDatabase property to True.
C.
Create a database restore process by using SQL Server Management Studio. Enable the option to Prompt before restoring each backup.
D.
Create a database restore process by using Transact-SQL. Include the CHECKSUM option.