verify and Delete old backup files upon successful completion of the backup job?

• Mani-584606

  SSChampion

  Points: 11788

  More actions

  September 7, 2012 at 4:36 pm

  #393134

  Hi,

  We need to backup 10 databases each of 120 gb each. Backup size of these databases is above 1TB.

  Currently, we are keeping 2 days worth of backups on disk. Just before running the full backup, we are running a job (default maintenace task) to delete 2 day's ago backup files.

  But now we want to keep only 1 days worth of backup on disk and then copy to Tape after the backup completion.

  How to schedule a job after the backup complete to delete the old backups?

  The automated script should validate and make sure the backup completed successfully before deleting the previous day's backups.

  Please advice.

• SpringTownDBA

  SSCertifiable

  Points: 6917

  More actions

  September 7, 2012 at 7:09 pm

  #1535360

  Don't reinvent the wheel. Ola hollengren's db maint scripts do exactly what you are looking for.