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.
| Author |
Topic |
|
kerrycorcoran
Starting Member
38 Posts |
 Posted - 2008-04-09 : 14:57:33
|
| Windows Server 2003R2 w/ Sp2SQL 2005 w/ Sp2Created weekly (full backup) and a daily (differential backup) Maintenance Plans using the wizard. I formatted the server, installed the OS and SQL. Restored the full backup (No Recovery Mode), then restored the differential backup (Recovery Mode), tested and all worked well.Then I noticed the original Maintenace Plans I created (Full and Differential) were gone; makes sense as I had formatted the server.Is there a way to create a Maintenance Plan file or script that I can save and just add back to the server??Hope that makes sense.Any help appreciated.Kerry |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 15:00:22
|
| Script it out or create new plan |
 |
|
|
kerrycorcoran
Starting Member
38 Posts |
Posted - 2008-04-09 : 15:22:07
|
quote:
Originally posted by sodeep
Script it out or create new plan
Can you elaborate on "script it"? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 15:27:25
|
| You can create Maintenance plan in SSIS (BIDS) . Save the package to safe location and redeploy it to server whenever you need. |
|
|
|
|
|
|
Maintenance Plan??