Red Gate forums :: View topic - How can I get the meta data from an SQB file directly?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

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

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ogrishman



Joined: 12 Apr 2010
Posts: 24

PostPosted: Mon Jul 22, 2013 4:12 pm    Post subject: How can I get the meta data from an SQB file directly? Reply with quote

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.

Thanks.[/img]
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Tue Jul 23, 2013 1:43 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
ogrishman



Joined: 12 Apr 2010
Posts: 24

PostPosted: Tue Jul 23, 2013 2:46 am    Post subject: Reply with quote

Thank you very much for providing this information petey!
Back to top
View user's profile Send private message
ogrishman



Joined: 12 Apr 2010
Posts: 24

PostPosted: Tue Jul 23, 2013 2:54 am    Post subject: Reply with quote

petey could you also provide the way to get the data return from "restore filelistonly"? Thanks.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Tue Jul 23, 2013 3:13 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
ogrishman



Joined: 12 Apr 2010
Posts: 24

PostPosted: Tue Jul 23, 2013 4:33 am    Post subject: Reply with quote

Thanks I'll give it a try.
Smile
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group