Append backup to existing transaction LOG backup file
Currently we use the following strategy for LOG backups:
- The first transaction LOG of the day is made using the WITH INIT command to a <db>_LOG.bak file
- The next transaction LOG's of that day are appended to the existing <db>_LOG.bak file. This way we store all transaction LOG backup's of one day in one file instead of a lot of LOG backup files. We take a LOG backup every hour.
I can't get this scenario working for the REDGATE backup's.
The first LOG backup using WITH INIT is working correctly
The next LOG backup's without using WITH INIT fail with the error below:
Backup file exists. Will not overwrite. File name: (f:\backup\ASPState_LOG.sqb)
Is it possible to append LOG backup's to an existing SQB file?