Add an @Stats variable to backups to show progress in the console

[kchenery]

When doing an adhoc backup its often helpful to output progress statistics with the STATS option. I have added an @Stats parameter to the dbo.DatabaseBackup command to facilitate this.

Note:

• By default it is set to NULL which is interpreted as "off" (existing behaviour is retained)
• It only accepts values between 1 and 100 (as well as NULL obviously) and will throw an error if this range is exceeded
• It has been added to both the BACKUP and RESTORE VERIFYONLY commands.

[dalekerr]

other requests for this (there may be others): Allow to have the backup job show the percentage completed #656 (2022-06-30) Backup & Restore Status #719 (2023-02-13)

Been doing some adhoc backups lately, would have liked this feature. @olahallengren, are you able to add a STATS option?