How to determine which backup files are Native and which are LiteSpeed? Which files were created using the Native SQL Server BACKUP DATABASE process and which were created by a LiteSpeed xp_backup_database or a LiteSpeed maintenance plan or job?
The query to determine the format of the backup files is:
exec sp_executesql N'exec master.dbo.xp_file_search @filename = @P1, @formattypemask = 7', N'@P1 varchar(1000)', 'D:\Backup\2000\Northwind200802192147*_Full.BKP'
The FileName: Northwind200802192147Native_Full.BKP and Northwind200802192147LiteSpeed_Full.BKP
The FormatType for the Native = 4 and for the LiteSpeed = 2
The FormatVersion for the Native = 1 and for the LiteSpeed = 47
Steps to reproduce:
I ran a native SQL Server backup, deselecting the checkbox "Use LiteSpeed" in the Type and Schedule screen of the Backup Database Wizard on my Northwind database, then immediately ran a LiteSpeed backup (within the same minute). Both these files were created by LiteSpeed, but one uses the LiteSpeed extended stored procedures and the other uses the native BACKUP DATABASE.
Also see SOL22742 and SOL25801
To verify a LiteSpeed or Native backup file:
/*Native*/RESTORE HEADERONLY FROM DISK = N'D:\Backup\Native_Northwind.BAK'
/*LiteSpeed*/exec master.dbo.xp_restore_headeronly @filename ='D:\Backup\Native_Northwind.BAK'
These queries indicate that the backup set is valid:
/*Native*/RESTORE VERIFYONLY FROM DISK = N'D:\Backup\Native_Northwind.BAK'
/*LiteSpeed*/exec master.dbo.xp_restore_verifyonly @filename ='d:\Backup\Northwind200612110950LiteSpeed_Full.BKP'
