Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Maintainence plan

Author  Topic 

mhdmehraj
Starting Member

6 Posts

Posted - 2011-02-23 : 01:47:38
hi,
After I manually create maintenance plan using SQL server Maintenence Plan Wizard with SQL Server Management Studio 2008, is there any way to create a script for all these setting that I've done for this maintainence plan ?

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2011-02-23 : 13:46:16
you can use SSIS to export/import the file if thats what you are trying to do..

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-02-23 : 14:58:01
I think Mhdmehraj is looking for how to script maintenance plan.
Go to Top of Page
   

- Advertisement -