SQL Server Performance Forum – Threads Archive
Best way to schedule jobs
If I have 4 databases. Which of the following schedules are the best? Why? 1. Set a maintenance plan to Optimize, Integrity check and database backup ALL Databases starting at 9:00pm 2. Set 4 maintenance plan to Optimize, Integrity check and database backup for each database starting at 9:00pm for the first DB, 10:00pm for the second, and so on.CanadaDBA
I’m with plan 2, because with 1 if something is wrong you backup all databases. With 2, you can check each manteinance plan and then backup.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
]]>