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 http://ola.hallengren.com

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

Step 2. Create a new database “DBAUtility“
pic1

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.

 image
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.

image

Good Luck!

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

tagged:

Leave a Reply