Thursday, August 21, 2008

Enable Maintainanace plan for SQL Server 2005

run the script:

use msdb
GO
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO

go to maintainance plan to see details about how to create them

No comments: