Which versions of SQL Server are supported? The jobs will automatically be configured to run against this database. To point to the database in which the objects will be created.

You just need to change this line of code in MaintenanceSolution.sql: The objects can be created in any database: master, msdb, or a utility database for database administrative scripts.

Check the output files in the error log directory.ĭo the objects need to be created in the master database? Verify that the backup files are being created. Verify that these jobs are completing successfully.

Go into / and start the jobs that have been created.

This script creates all the objects and jobs that you need. The cleanup time is the number of hours after which the backup files are deleted. Follow these steps.Īnd replace NULL with the path to your backup directory.Īnd replace NULL with your cleanup time. Getting started with the SQL Server Maintenance Solution is easy.

Frequently Asked Questions Getting Started How do I get started with the SQL Server Maintenance Solution?

Use of master database in sql server