SQL Server Performance Forum – Threads Archive
Best way to schedule jobsIf 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.
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.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.