What's the easiest way to get the metadata from sqb files?
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;