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.
- Code: Select all
CREATE TABLE sqb
id INT IDENTITY
INSERT INTO sqb
EXECUTE master..sqlbackup '-sql "RESTORE SQBHEADERONLY
FROM DISK = [c:\\temp\\*.sqb] WITH SINGLERESULTSET"'
SELECT * FROM sqb;