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

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

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

Postby ogrishman » Mon Jul 22, 2013 4:12 pm

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.
Image
Thanks.[/img]
ogrishman
 
Posts: 29
Joined: Mon Apr 12, 2010 8:21 pm

Postby petey » Tue Jul 23, 2013 1:43 am

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 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm

Postby ogrishman » Tue Jul 23, 2013 2:46 am

Thank you very much for providing this information petey!
ogrishman
 
Posts: 29
Joined: Mon Apr 12, 2010 8:21 pm

Postby ogrishman » Tue Jul 23, 2013 2:54 am

petey could you also provide the way to get the data return from "restore filelistonly"? Thanks.
ogrishman
 
Posts: 29
Joined: Mon Apr 12, 2010 8:21 pm

Postby petey » Tue Jul 23, 2013 3:13 am

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 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm

Postby ogrishman » Tue Jul 23, 2013 4:33 am

Thanks I'll give it a try.
:)
ogrishman
 
Posts: 29
Joined: Mon Apr 12, 2010 8:21 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests