Thanks petey for your reply. Here are the logs for the slowest and fastest nights.
Fastest night on Feb 8th:
SQL Backup log file 6.4.0.56
-SQL "RESTORE DATABASE [MyDB] FROM DISK = '\\BKUP\Nightly_Full\FULL_(local)_MyDB_20110208_020226.sqb' WITH RECOVERY, MOVE 'MyDB_Data' TO 'E:\Data\MyDB_data.mdf', MOVE 'MyDB_Log' TO 'E:\Log\MyDB_log.ldf', REPLACE, MAILTO_ONERROR = 'dba@email.com', THREADPRIORITY = 6 "
PROCESSES COMPLETED SUCCESSFULLY
2/8/2011 4:34:06 AM: Restoring MyDB (database) from:
2/8/2011 4:34:06 AM: \\BKUP\Nightly_Full\FULL_(local)_MyDB_20110208_020226.sqb
2/8/2011 4:34:06 AM: RESTORE DATABASE [MyDB] FROM VIRTUAL_DEVICE = 'SQLBACKUP_D0433D67-5A3F-4C91-B97D-AD3C6DE3910F', VIRTUAL_DEVICE = 'SQLBACKUP_D0433D67-5A3F-4C91-B97D-AD3C6DE3910F01', VIRTUAL_DEVICE = 'SQLBACKUP_D0433D67-5A3F-4C91-B97D-AD3C6DE3910F02' WITH BUFFERCOUNT = 18, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , RECOVERY, MOVE 'MyDB_Data' TO 'E:\Data\MyDB_data.mdf', MOVE 'MyDB_Log' TO 'E:\Log\MyDB_log.ldf', REPLACE
2/8/2011 6:27:38 AM: Processed 14817152 pages for database 'MyDB', file 'MyDB_Data' on file 1.
2/8/2011 6:27:38 AM: Processed 56 pages for database 'MyDB', file 'MyDB_Log' on file 1.
2/8/2011 6:27:38 AM: RESTORE DATABASE successfully processed 14817208 pages in 6803.218 seconds (17.841 MB/sec).
2/8/2011 6:27:38 AM: SQL Backup process ended.
2/8/2011 6:27:38 AM: Deleted msdb entries older than 11/10/2010 6:27:38 AM
2/8/2011 6:27:38 AM: Deleted local history entries older than 11/10/2010 6:27:38 AM
Slowest night on Feb 14th:
SQL Backup log file 6.4.0.56
-SQL "RESTORE DATABASE [MyDB] FROM DISK = '\\BKUP\Nightly_Full\FULL_(local)_MyDB_20110214_020121.sqb' WITH RECOVERY, MOVE 'MyDB_Data' TO 'E:\Data\MyDB_data.mdf', MOVE 'MyDB_Log' TO 'E:\Log\MyDB_log.ldf', REPLACE, MAILTO_ONERROR = 'dba@email.com', THREADPRIORITY = 6 "
PROCESSES COMPLETED SUCCESSFULLY
2/14/2011 2:36:49 AM: Restoring MyDB (database) from:
2/14/2011 2:36:49 AM: \\BKUP\Nightly_Full\FULL_(local)_MyDB_20110214_020121.sqb
2/14/2011 2:36:49 AM: RESTORE DATABASE [MyDB] FROM VIRTUAL_DEVICE = 'SQLBACKUP_72110CCA-A1CC-48F6-9145-201A2818C995', VIRTUAL_DEVICE = 'SQLBACKUP_72110CCA-A1CC-48F6-9145-201A2818C99501', VIRTUAL_DEVICE = 'SQLBACKUP_72110CCA-A1CC-48F6-9145-201A2818C99502' WITH BUFFERCOUNT = 18, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , RECOVERY, MOVE 'MyDB_Data' TO 'E:\Data\MyDB_data.mdf', MOVE 'MyDB_Log' TO 'E:\Log\MyDB_log.ldf', REPLACE
2/14/2011 4:54:31 AM: Processed 14865624 pages for database 'MyDB', file 'MyDB_Data' on file 1.
2/14/2011 4:54:31 AM: Processed 1 pages for database 'MyDB', file 'MyDB_Log' on file 1.
2/14/2011 4:54:31 AM: RESTORE DATABASE successfully processed 14865625 pages in 8258.624 seconds (14.745 MB/sec).
2/14/2011 4:54:31 AM: SQL Backup process ended.
2/14/2011 4:54:32 AM: Deleted msdb entries older than 11/16/2010 4:54:31 AM
2/14/2011 4:54:32 AM: Deleted local history entries older than 11/16/2010 4:54:31 AM / comments
- Community
- SQL Backup Previous Versions
- Restore process has erratic speed fluctuations
Thanks petey for your reply. Here are the logs for the slowest and fastest nights.
Fastest night on Feb 8th:
SQL Backup log file 6.4.0.56
-SQL "RESTORE DATABASE [MyDB] FROM DISK = '\\BKUP\Nightly_F...
0 votes
