April 9, 2008 at 12:55 pm
Windows Server 2003R2 w/ Sp2
SQL 2005 w/ Sp2
Created 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
April 9, 2008 at 3:30 pm
Did you restore MSDB, where your jobs were saved?
April 9, 2008 at 3:51 pm
kerry.corcoran (4/9/2008)
Windows Server 2003R2 w/ Sp2SQL 2005 w/ Sp2
...
Is there a way to create a Maintenance Plan file or script that I can save and just add back to the server??
You might try exporting them as dtsx files and then importing them on the fresh install. I don't know if there are any unknown pitfalls to that approach, but I had some success with that method to fix a maint plan that I'd broken during an in-place upgrade. Not quite the same situation you've described, but it might be worth looking into.
Log in to Integration Services via SSMS and expand Stored Packages --> MSDB --> Maintenance Plans. Right-click and select "Export Package...". There's probabaly a little more to it than that, but IIRC I had good luck with BOL when I last tried it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply