What does Keyword STATS Indicates in Backup Scripts in SQL Server?

Question

Sushant Mishra · Answer

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

interview

What does Keyword STATS Indicates in Backup Scripts in SQL Server?

Can you answer this question?

1 Answers