August 24, 2006 at 4:56 pm
Hi all,
I am sure that I have read somewhere that it is best-practice when creating Maintenance Plans to seperate Optimization/Integrity, Transaction Logging, and Complete Backups into seperate plans. However I cannot find any information to backup this view, so now I am wondering if I this opinion is indeed correct or not.
What is the consensus on the best practice regarding the creation of Maintenance? Is it best to seperate them out, or is one plan that does the lot sufficient? If spliting the plans is best, why is it best?
Cheers,
Shawn
August 28, 2006 at 8:32 am
They will be separate jobs anyway, so I put them into one plan.
I do separate system from user dbs. Usually 2 plans per server unless I have special cases for some user dbs.
August 28, 2006 at 2:15 pm
Thanks Steve, much appreciated.
Shawn.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply