How can we help you today? How can we help you today?

Establish whether log backup contains non-logged transactions

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
kamikaiza
0

Comments

1 comment

Sort by
  • RichardL
    Hi @kamikaiza

    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.
    RichardL
    0

Add comment

Please sign in to leave a comment.