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?
A.
Create two SQL Server Integration Services (SSIS) packages by using a single schedule.
B.
Insert a new row to dm_os_schedulers.
C.
Create a database maintenance plan by using the Database Maintenance Wizard.
D.
Create two SQL Agent jobs by using a single schedule.