• Adam Thurgar

Database Backups and Maintenance Solution

When I started with SQL Server over 20 years ago we wrote our own backup and maintenance stored procedures and then created SQL Server Agent jobs to run these. It was a semi automated system, but still required some manual tweaking. It then became more difficult to ensure that the same version of these stored procedures was deployed across all system.

Over the last few years I have adopted the industry de-facto standard for backups and maintenance - Ola Hallengren's SQL Server Maintenance Solution. It is by far the most complete and thorough set of scripts for ensuring that your databases are backed up, error free and optimised.

You can download the free solution from his web site.