How can I get the meta data from an SQB file directly?

ogrishmanogrishman Posts: 81 Bronze 4
edited July 22, 2013 11:33PM in SQL Backup Previous Versions
How can I get the meta data from an SQB file directly without an instance that has RedGate SQL Backup installed?
I need to get those information directly in an automatic way. After some investigation I can got the LSNs. But I still can't got other information. Please check the following snapshot. Hope you can give me some suggestions.
MSffqJq.png
Thanks.[/img]
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    server name - offset 294, 164 bytes
    82 2-byte character values.

    database name - offset 518, 258 bytes
    129 2-byte character values.

    group ID - offset 288, 4 bytes
    4 byte integer value.

    backup type - offset 506
    1 = full, 2 = differential, 3 = log, 4 = file
    14 = file differential, 19 = partial, 20 = differential partial,

    native backup size - offset 9, 8 bytes
    Is a 64-bit integer value.

    database size - offset 1008, 8 bytes
    Is a 64-bit integer value.

    backup start - offset 17, 8 bytes
    8-byte floating point value, where the integer portion represents the number of days since 30 Dec 1899, and the fractional portion represents the fraction of a 24-hour day that has elapsed. If it helps, the range for this data type ranges from 5.0 x 10^-324 to 1.7 x 10^308.

    backup end - offset 25, 8 bytes
    As above for backup start.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • ogrishmanogrishman Posts: 81 Bronze 4
    Thank you very much for providing this information petey!
    · Share on Twitter
  • ogrishmanogrishman Posts: 81 Bronze 4
    petey could you also provide the way to get the data return from "restore filelistonly"? Thanks.
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    That isn't possible without SQL Server. One option is to use the SQL Backup converter (SQBConverter.exe) to convert SQL Backup files to native backup files, then use the Express editions of SQL Server to run and return the results of the RESTORE FILELISTONLY command via the command line interface (osql).
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • ogrishmanogrishman Posts: 81 Bronze 4
    Thanks I'll give it a try.
    :)
    · Share on Twitter
Sign In or Register to comment.