1 Answers

Sushant Mishra
Sushant Mishra

It displays a message of percentage complete when the backup is in process mode. its default value of the stats is 10 and hence if we do not specify the stats, keywords, SQL Server displays the percentage completion at every 10 percentage.

BACKUP DATABASE [School_Context]
TO
DISK = N'D:\a' WITH FORMAT,
STATS = 20
GO

It will give output as


Answer