You administer a SQL Server 2008 infrastructure. A SQL Server instance contains a transactional database. You design a plan to back up and restore a database. The current transactional database backup strategy has the following features:

You simulate a complete hardware failure at 15:29 hr on Monday. The test includes inconsistent application data beginning at 15:00 hr. You need to ensure that you can restore the database up You need to ensure that the backup jobs have a minimal effect on the performance of the server to 15:00 hr on Monday. Which three steps should you perform? (Each correct answer presents part of the solution. Choose three.)

Question

You administer a SQL Server 2008 infrastructure. A SQL Server instance contains a transactional database. You design a plan to back up and restore a database. The current transactional database backup strategy has the following features:

You simulate a complete hardware failure at 15:29 hr on Monday. The test includes inconsistent application data beginning at 15:00 hr. You need to ensure that you can restore the database up You need to ensure that the backup jobs have a minimal effect on the performance of the server to 15:00 hr on Monday. Which three steps should you perform? (Each correct answer presents part of the solution. Choose three.)

Accepted Answer

A. Restore the differential backups from Monday. C. Restore log backups from Monday 02:15 hr to 15:15 hr by using the STANDBY option. D. Restore the full back up from Saturday.

Answer

B. Restore the differential backups from Sunday.

Answer

E. Restore log backups from Monday 02:15 hr to 15:15 hr by using the STOPAT Option.

You administer a SQL Server 2008 infrastructure. A SQL Server instance contains a transactional database. You design a plan to back up and restore a database. The current transactional database…

Question

Options

How the community answered

Community Discussion