January 4, 2011 at 6:04 am
Hi,
I have created one maintenance plan which performs backups,index rebuilding,stats maintenance task.We have 8 servers and I don't want to go through all the same procedure of setting up maintenance plan using wizard for all other 7 servers.Is there any other way of doing this; as I have read that maintenance plan script can't be generated. I am using SQL Server 2008.
Please help me out in this regard.
Thanks.
January 4, 2011 at 7:19 am
Since the maintenance plan actually creates an SSIS package and a SQL Server Agent job, you can deploy these to the other servers.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 4, 2011 at 11:17 am
Pls Check this
Thank You,
Best Regards,
SQLBuddy
January 4, 2011 at 11:52 pm
sqlbuddy123 (1/4/2011)
Pls Check this
This article describes the steps needed for the solution I already gave. However, the article is written by someone who doesn't really understand Integration Services. Fortunately, it is written well enough to get you started.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 5, 2011 at 1:05 am
abdul.samad.121 (1/4/2011)
Hi,I have created one maintenance plan which performs backups,index rebuilding,stats maintenance task.We have 8 servers and I don't want to go through all the same procedure of setting up maintenance plan using wizard for all other 7 servers.Is there any other way of doing this; as I have read that maintenance plan script can't be generated. I am using SQL Server 2008.
Please help me out in this regard.
Thanks.
Iam just wondering, you have 1 maintenance task (so 1 schedule) where you reindex/update stats/make backups/full/trans ?
guess you dont use full recovery
guess you have a maintenance window every night, or you dont run the maintenance plan every day.
It is from my point of view abit wierd combo to put in the same schedule just wondering about the schedule and the idea behind it
January 5, 2011 at 1:39 am
You can have several subplans with different schedules, if I'm not mistaken.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply