PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the transaction log backup schedule meets the following requirements: -Log backups occ

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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply