How can we help you today? How can we help you today?

How to programmatically identify the type of an sqb file?

Hey,

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

Thanks.
ogrishman
0

Comments

1 comment

Sort by
  • petey
    Using the sqbutility extended stored procedure:
    DECLARE @type INT
EXEC master..sqbutility 1015, 'e:\temp\pubs.sqb', @type OUTPUT
SELECT @type
    where @... 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.
    petey
    0

Add comment

Please sign in to leave a comment.