How to change the STATS parameter in LiteSpeed backups
Changing the STATS parameter for all backups may be changed through the setup parameters of SQL Server.
This parameter may not be changed when backing up individual databases using the LiteSpeed Backup Wizard, only via scheduled jobs. The job step from a LiteSpeed MP (the parameter doesn't appear in the native SQL Server job steps):
exec master.dbo.xp_backup_database @database = 'Northwind', @GUID = '3BE7183C-36AD-4561-B30A-E133AAE2D5C1', @filename = 'D:\Backup\Northwind200611281101LiteSpeed_Full.BKP', @backupname = 'Northwind backup', @desc = 'Backup of Northwind on 2006-11-28 11:01:09', @logging = 0, @with = 'SKIP', @with = 'STATS = 5'
All versions of SQL Server
Versions 4.5 and 4.6 of LiteSpeed
