What's the easiest way to get the metadata from sqb files?

ogrishmanogrishman Posts: 75 Bronze 3
edited April 23, 2012 10:48PM in SQL Backup Previous Versions
Hi,

For example, if I have some sqb files located in c:\temp, what's the easiest way to get the meta information(such as first lsn last lsn etc) in a easy to use form from them? The following code is currently what I have, but I have difficult in getting the individual item value. Hope you can give me some suggestions. Thanks.
CREATE TABLE sqb
(
 id INT IDENTITY
        PRIMARY KEY,
 DATA NVARCHAR(1000)
)


INSERT INTO sqb
EXECUTE master..sqlbackup '-sql "RESTORE SQBHEADERONLY 
FROM DISK = [c:\temp\*.sqb] WITH SINGLERESULTSET"' 


SELECT * FROM sqb;

Comments

Sign In or Register to comment.