locked
Create a new maintenance plan RRS feed

  • Question

  • I have installed SQLServer 2005 from Small Business Server premium edition.  The package has been upgraded to SP2 and all the fixes have been applied.

     

    I want to create a new maintenance plan to automate my DB backup procedures using SQL Server Management Studio.  I start Management Studio and right click on the management folder and I I see is "Refresh"  there is no "Create New Maintenance" plan presented.

     

    I have tried this using the sa built-in account and the server administrator account both of which have sysadmin priviledges.  I have also tried it from a client machine with another sysadmin userid but they all give the same results.

     

    I checked to see if SSIS was installed.  The add/remove programs wizard for SQL Server shows Integration Services SP2 is installed but I went ahead anyway and re-installed without error.

     

    It seems that either SSIS is not running or I my user roles are preventing the maintenance wizard from running.  Is there some way that I can tell if, in fact, SSIS is properly installed and running?

     

    Thanks.

    Wednesday, May 30, 2007 5:51 PM

Answers