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 2005 Forums
 SQL Server Administration (2005)
 How to generate script maintenance plan

Author  Topic 

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2010-01-31 : 07:09:02
I have to maintenance jobs which run full backup / daily differential backup.

Is it possible to generate the script via sql server 2005, i tried right clicking the maintenance plans, but it doesn't give the option of scripts.

Thank you very much for the helpful info.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2010-01-31 : 09:15:39
Check out Tara's Script.
Go to Top of Page

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2010-01-31 : 21:48:30
Can you please provide TARA's Link...

Thank you very much for the info.
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-02-01 : 01:41:56
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -