How to programmatically identify the type of an sqb file?

ogrishman

Hey,

How to programmatically identify the type of an sqb file? Such as whether it's an full backup or log backup.

Thanks.

petey

Using the sqbutility extended stored procedure:

DECLARE @type INT
EXEC master..sqbutility 1015, 'e:\temp\pubs.sqb', @type OUTPUT
SELECT @type

where @type 1 = database full, 2 = database differential, 3 = log, 4 = file, 14 = file differential, 19 = partial, 20 = partial differential

Reading the file header:

Read value for byte offset 505. Values as above i.e. 1 = database full, 2 = database differential etc.