By: Greg Robidoux
Overview
The RESTORE WITH STATS option allows you to see how far along the restore process is, this can be used for RESTORE DATABASE, RESTORE LOG, RESTORE VERIFYONLY.
Explanation
The RESTORE WITH STATS option will give you an idea of where the restore process currently is an the overall process. This information is presented in percentage of completion. The default is to display after every 10% or a percentage value can be specified. This information is displayed on the Messages tab in your query window.
T-SQL
Restore a full database with default stats setting
The following will show the percentage complete after each 10% segment.
RESTORE DATABASE 'AdventureWorks' FROM DISK = 'C:\AdventureWorks.BAK' GO
Restore a full database with stats showing for each 1 percent complete
This will show progress after each 1% of completion.
RESTORE DATABASE 'AdventureWorks' FROM DISK = 'C:\AdventureWorks.BAK' WITH STATS = 1 GO
SQL Server Management Studio
When restoring a database using SSMS, this information is displayed as shown in the highlighted section below. The default is 10% which can not be changed for the GUI.
