Here is a a 1-2-3 guide to implement his solution –a solution used by Citi Bank, Well Fargo, Target, several Universities and a whole bunch of other companies and organizations. More info on the web page

Step 1. Download MaintenanceSolution.sql. This script creates all the objects and jobs that you need.

Step 2. Create a new database “DBAUtility“

Step 3. Open query window in SSMS and Paste the MaintenanceSolution.sql script. Modify the script to Use [DBAUtility] (Default is Master). Set @BackupDirectory to your root directory (a folder with servername + db’s name is created at fisrt run). Set @CleanupTime in hours, after wich backupfiles will be deleted –no data here and backupfiles stays in Backupdirectory for ever – in the picture I use 23 hrs.

Execute the query and the script will create several stored procedures and a Command log table.

Step 4. Schedule the jobs according to you’r backup strategy, a best practice is to run Integrity Check before a full backup.


Good Luck!

by Thorbjørn Værp on Nov 28, 2016 at 9:01 PM


Leave a Reply