Friday, February 12, 2016

Scripting your SQL Server Maintenance Tasks

When you normally set up maintenance for your SQL Server databases, most of the time you will end up manually setting up these jobs and tasks from within the SQL Server Management Studio User Interface.

However, if you like to simplify the management of these tasks, then it makes sense to use scripts to accomplish this.

Fortunately, a set of scripts already exist that allow you to do just that!

You can download the SQL Server Maintenance scripts from here that allow you to perform a wide variety of SQL Server Maintenance operations effortlessly: https://ola.hallengren.com/

No comments:

Post a Comment