deleting transaction logs

dgrace

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

ChrisAVWood

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