patternsqlModerate
Decrypt T-SQL log backup header and read LSN
Viewed 0 times
headerlogsqlreaddecryptlsnandbackup
Problem
For some reason I need to read the LSN from the T-SQL logs backups without restoring them or even their headers (I assume even restoring only their headers will change the LSN on the database side too, but I'm not sure).
So is the T-SQL log backup files encrypted or does they have special structure? Any information as to where should I start?
Could anyone confirm or denies that restoring the header only wouldn't affect the sys.fn_dblog or anything else?
So is the T-SQL log backup files encrypted or does they have special structure? Any information as to where should I start?
Could anyone confirm or denies that restoring the header only wouldn't affect the sys.fn_dblog or anything else?
Solution
Could anyone confirm or denies that restoring the header only wouldn't
affect the sys.fn_dblog or anything else?
RESTORE HEADERONLY doesn't target any database in its syntax:
It reads the backup device and returns data to the client about what's in the backup. It won't affect your databases in any way.
affect the sys.fn_dblog or anything else?
RESTORE HEADERONLY doesn't target any database in its syntax:
RESTORE HEADERONLY FROM It reads the backup device and returns data to the client about what's in the backup. It won't affect your databases in any way.
Code Snippets
RESTORE HEADERONLY FROM <backup_device>Context
StackExchange Database Administrators Q#252195, answer score: 10
Revisions (0)
No revisions yet.