I have built a maintenace plan that is quite basic and generic. It is set to execute against all database on the server. It covers the basic functions backup, integrity and optimizations. I set all my basic servers databases to simple model and do not worry about the transaction log backups. I would like to implement and replicate the functionaly across multiple servers at least our smaller and simple configuration servers. Is there a way to script out the maintence plan so that it can ported to a new server?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
2005 Maintenance Plan - Script Out
- Thread starter TWillard
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
Nope. The maintenance plans are SSIS packages and need to be built by hand for each server.
You can build a package in the BI editor and then deploy it to each server (which would probably be easier than manually making one for each server).
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
You can build a package in the BI editor and then deploy it to each server (which would probably be easier than manually making one for each server).
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question