* Show progress after every 10%
Create a full backup with progress stats
This command creates a full backup and also displays the progress of the backup.
The default is to show progress after every 10%.
-----start code
BACKUP DATABASE HRD
TO DISK = 'D:\HRD.BAK'
WITH STATS
GO
-----end code
* Show progress after every 1%.
-----start code
BACKUP DATABASE HRD
TO DISK = 'D:\HRD_After_1.BAK'
WITH STATS = 1
GO-----end code