Best way to schedule jobs | SQL Server Performance Forums

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.
]]>