What are the challenges you face when working across database platforms? Take the survey
Options

deleting transaction logs

dgracedgrace Posts: 5
edited August 28, 2009 5:41PM in SQL Backup Previous Versions
Maybe I setup my backup jobs wrong, but is there a way to delete the transaction log backups only after a succesful differential backup?

I've setup 3 jobs, one each for full, differential and transactin log. I don't want to delete the transaction log backup unless I am certain I have a succesful differential but I don't see any way to do this in sqlb6. Did I miss something?

Thanks,

David

Comments

  • Options
    David,

    Usually you want to delete backup files of the same type as you have just created. A solution that I use quite a lot is to have the job have a Raiserror step. The error number has to be greater than 50000 and it needs to have @with_log = 'TRUE' so it writes to the event viewer log. Then an alert can pick up the error number and that fires another job that does what you want to do, in this case start deleting log backups.

    HTH

    Chris
    English DBA living in CANADA
Sign In or Register to comment.