The following is a sample output from the error log: RESTORE DATABASE successfully processed 315 pages in 0.372 seconds (6.604 MB/sec) You can use these details to estimate the time that's required to back up and restore the database in its current state.

The SQL Server error log contains information about previous backup and restore operations. If you suspect that the backup operations are either stopped or taking too long to finish, you can use one or more of the following methods to estimate the time for completion or to track the progress of a backup or restore operation: Backup/Restore throughput depends on how well the underlying I/O subsystem is optimized to handle the I/O volume. Original product version: SQL Server Original KB number: 224071 Backup and restore operations take a long timeīackup and restore operations are I/O intensive. This article provides solutions for common issues that you might experience during Microsoft SQL Server backup and restore operations, and provides references to further information about these operations.

Sql server vdi backup