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?



    Wednesday, May 30, 2007 5:51 PM