Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

How to create own maintenance subplan in SQL server 2005 (or) 2008 ?

share|improve this question

migrated from stackoverflow.com Jan 29 '10 at 2:02

This question came from our site for professional and enthusiast programmers.

    

1 Answer 1

Open Management Studio. Connect to the SQL Server instance. In the Object Explorer pane, go to Management and you should see Maintenance Plans in there. Right click and you should find a wizard to make a new one.

share|improve this answer
    
I get the custom designed (inbuilt) or predifined plans, but I want to build my own plan ..I have my own script and I would like to schedule it . How do I do it ? –  Anonymous Jan 29 '10 at 1:55
1  
A maintenance plan is really just an SSIS package. You can schedule almost anything by going into SQL Agent and making a job there. The steps can be T-SQL, or SSIS package, PowerShell script, and more. –  Rob Farley Jan 29 '10 at 2:08

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.