Establish whether log backup contains non-logged transactions
kamikaiza
Posts: 1 New member
Hi guys. We've a number of prod dBs which, for historical reasons, are in BULK_LOGGED mode. Recently I had to perform a PIT recovery to a dev environment, which failed due to a non-logged transaction in the final log backup - fair enough, this is a risk of the recovery model. However, this only came to light right at the end of the restore and wasted a lot of time.
We're having discussions as to whether we can switch to FULL recovery, but in the meantime is there a method to find whether a log backup contains a non-logged transaction? In native mode, running the following returns a non-logged flag:
RESTORE HEADERONLY FROM DISK='logbackuphere'
However, SQL Backups HEADERONLY doesn't seem to offer the same functionality. Any ideas?
Thanks,
Grant
We're having discussions as to whether we can switch to FULL recovery, but in the meantime is there a method to find whether a log backup contains a non-logged transaction? In native mode, running the following returns a non-logged flag:
RESTORE HEADERONLY FROM DISK='logbackuphere'
However, SQL Backups HEADERONLY doesn't seem to offer the same functionality. Any ideas?
Thanks,
Grant
Tagged:
Answers
This looks like a question that one of Support engineers will need to investigate for you.
If you've a got support contract, please send us a ticket. Provide as much information as you can - screenshots of any errors, log files etc – so we can help you as fast as possible.
If you're not covered by a Support contract at the moment, email our Sales team at sales@red-gate.com, and they'll be able to help.
Redgate Software