February 22, 2011 at 11:54 pm
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 the maintainence plan ?
So that i have run the same scripts in all the other servers
February 23, 2011 at 12:31 am
I am afrid you may not able to do this with Management studio.
There is a "view T-SQL" button could let you view the T-SQL for each component, but these script couldn't be implemented to other SQL Server without modification. You could create a stored procedure to backup each database.
There are lots of source code for database backup, here is one example for your refernece:
http://www.geekzilla.co.uk/View487F82A5-C96B-4660-A070-F7C8B7FC4431.htm
February 23, 2011 at 1:10 am
When you create your maintenance plan, you have the option to view the t-sql script of the maintenance plan(the task which you configured for maintenance).
To do this-- select edit of your maintenance task and then you will see at bottom as 'view t-sql'
----------
Ashish
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply