You administer a database for an online ordering system. You plan to create a disaster recovery plan that uses transaction log backups by using only Microsoft SQL Server native tools. You need to ensure that the transaction log backup schedule meets the following requirements:

Log backups occur every 15 minutes between 09:00 hours and 17:00

hours.

Log backups occur every hour between 17:00 hours and 09:00 hours.

What should you do?

Question

You administer a database for an online ordering system. You plan to create a disaster recovery plan that uses transaction log backups by using only Microsoft SQL Server native tools. You need to ensure that the transaction log backup schedule meets the following requirements:

Log backups occur every 15 minutes between 09:00 hours and 17:00

hours.

Log backups occur every hour between 17:00 hours and 09:00 hours.

What should you do?

Accepted Answer

B. Insert a new row to dm_os_schedulers.

Answer

A. Create two SQL Server Integration Services (SSIS) packages by using a single schedule.

Answer

C. Create a database maintenance plan by using the Database Maintenance Wizard.

Answer

D. Create two SQL Agent jobs by using a single schedule.

You administer a database for an online ordering system. You plan to create a disaster recovery plan that uses transaction log backups by using only Microsoft SQL Server native tools. You need to…

Question

Options

How the community answered

Community Discussion