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. Troubleshoot SQL Server backup and restore operations
