PrepAway - Latest Free Exam Questions & Answers

Tag: Start whenever the CPUs become idle does not execute

What should you do to automate these tasks to occur at the scheduled time on all weekdays?

You are a database administrator for your company. You are managing the production database Prod1 thatresides on the SQL Server 2008 instance named Sql1.
You perform the following tasks on Prod1 as a part of your daily activities:
? Perform a differential database backup at 8:00 P.M.
? Rebuild indexes on database tables at 9:00 A.M.
? Perform a backup of the transaction log in the database at 12:00 P.M.
? Update the database statistics at 8:00 A.M.
You want to automate these tasks to occur at the scheduled time on all weekdays. exhibit What should you do? (Choose two. Each correct answer represents part of the solution.)