WHAT DOES KEYWORD STATS INDICATES IN BACKUP SCRIPTS IN SQL SERVER?

Sushant Mishra

Total Post:37

Points:185
Posted by  Sushant Mishra
 175  View(s)
Ratings:
Rate this:
  1. Sushant Mishra

    Post:37

    Points:185
    What does Keyword STATS Indicates in Backup Scripts in SQL Server?

    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


      Modified On Sep-18-2017 07:12:13 AM

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!