interview

home / developersection / interviews / what does keyword stats indicates in backup scripts in sql server?

Ask Question
Sushant Mishra

Other

Follow
Can you answer this question?
Answer

1 Answers

Sushant Mishra

Sushant Mishra

16-Sep-2017

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

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

MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy