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“
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!