Logs from one of the failed restore attempts as follows:
06/11/2008 13:32:23: Reading SQB file header of "E:\MSSQL\Backup\FULL_(local)_ispi_live_20081106_124235.sqb"
06/11/2008 13:32:23: Backup group ID : 50599725
06/11/2008 13:32:23: File number : 1 of 1
06/11/2008 13:32:23: Threads : 3 (multi-threaded file)
06/11/2008 13:32:23: Backup type : 1 (Database)
06/11/2008 13:32:23: Native backup size : 122.977 GB
06/11/2008 13:32:23: Database size : 313.148 GB
06/11/2008 13:32:23: Backup start : 06 November 2008 12:42:35
06/11/2008 13:32:23: Backup end : 06 November 2008 13:00:58
06/11/2008 13:32:23: Server name : MSDB03
06/11/2008 13:32:23: Database name : ispi_live
06/11/2008 13:32:23: First LSN : 1667769000007261300202
06/11/2008 13:32:23: Last LSN : 1667770000001120300001
06/11/2008 13:32:23: Checkpoint LSN : 1667769000007261300202
06/11/2008 13:32:23: Database backup LSN : 1667738000005405500116
SQL Backup log file 5.3.0.178
-SQL "RESTORE FILELISTONLY FROM DISK='E:\MSSQL\Backup\FULL_(local)_ispi_live_20081106_124235.sqb' "
----------------------- PROCESSES COMPLETED SUCCESSFULLY --------------------
06/11/2008 13:32:23: Reading filelist of "E:\MSSQL\Backup\FULL_(local)_ispi_live_20081106_124235.sqb"
06/11/2008 13:32:23: RESTORE FILELISTONLY FROM VIRTUAL_DEVICE = 'SQLBACKUP_3D691755-004C-4AC5-958C-224BA27D7ADE' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576
06/11/2008 13:32:24: Logical name : ispi_live_Data
Type : D (Data file)
Physical name : E:\MSSQL\Data\ispi_live_Data.mdf
Size : 304.369 GB
Logical name : ispi_live_Log
Type : L (Log file)
Physical name : E:\MSSQL\Data\ispi_live_Log.ldf
Size : 8.779 GB
06/11/2008 13:32:24: SQL Backup process ended.
SQL Backup log file 5.3.0.178
-SQL "RESTORE DATABASE [ispi_live] FROM DISK = 'E:\MSSQL\Backup\FULL_(local)_ispi_live_20081106_124235.sqb' WITH NORECOVERY "
----------------------------- ERRORS AND WARNINGS -----------------------------
06/11/2008 13:33:44: Restoring ispi_live (database) from:
06/11/2008 13:33:44: E:\MSSQL\Backup\FULL_(local)_ispi_live_20081106_124235.sqb
06/11/2008 13:33:44: RESTORE DATABASE [ispi_live] FROM VIRTUAL_DEVICE = 'SQLBACKUP_7B9121DA-57C0-44C9-A25F-09A86FF46A16', VIRTUAL_DEVICE = 'SQLBACKUP_7B9121DA-57C0-44C9-A25F-09A86FF46A1601', VIRTUAL_DEVICE = 'SQLBACKUP_7B9121DA-57C0-44C9-A25F-09A86FF46A1602' WITH BUFFERCOUNT = 18, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , NORECOVERY
06/11/2008 13:49:56: Thread 0 error:
Process terminated unexpectedly. Error code: -2139684853
06/11/2008 13:49:56:
06/11/2008 13:49:56: Thread 1 error:
Failed to service command. Error code: -2139684860
Process terminated unexpectedly. Error code: -2139684860
06/11/2008 13:49:56:
06/11/2008 13:49:56: Thread 2 error:
Failed to service command. Error code: -2139684860
Process terminated unexpectedly. Error code: -2139684860
06/11/2008 13:49:56:
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_7B9121DA-57C0-44C9-A25F-09A86FF46A1601:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
Logs from successful restore (after backup using single thread)
06/11/2008 17:28:04: Reading SQB file header of "E:\MSSQL\Backup\FULL_(local)_ispi_live_20081106_154451.sqb"
06/11/2008 17:28:04: Backup group ID : 243946205
06/11/2008 17:28:04: File number : 1 of 1
06/11/2008 17:28:04: Backup type : 1 (Database)
06/11/2008 17:28:04: Native backup size : 123.032 GB
06/11/2008 17:28:04: Database size : 313.148 GB
06/11/2008 17:28:04: Backup start : 06 November 2008 15:44:51
06/11/2008 17:28:04: Backup end : 06 November 2008 16:12:48
06/11/2008 17:28:04: Server name : MSDB03
06/11/2008 17:28:04: Database name : ispi_live
06/11/2008 17:28:04: First LSN : 1667773000007651500151
06/11/2008 17:28:04: Last LSN : 1667774000003283400001
06/11/2008 17:28:04: Checkpoint LSN : 1667773000007651500151
06/11/2008 17:28:04: Database backup LSN : 1667771000006950500213
SQL Backup log file 5.3.0.178
-SQL "RESTORE FILELISTONLY FROM DISK='E:\MSSQL\Backup\FULL_(local)_ispi_live_20081106_154451.sqb' "
----------------------- PROCESSES COMPLETED SUCCESSFULLY --------------------
06/11/2008 17:28:04: Reading filelist of "E:\MSSQL\Backup\FULL_(local)_ispi_live_20081106_154451.sqb"
06/11/2008 17:28:04: RESTORE FILELISTONLY FROM VIRTUAL_DEVICE = 'SQLBACKUP_A4E3EFF3-EB55-4EC0-9106-AEF5E91B285D' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576
06/11/2008 17:28:05: Logical name : ispi_live_Data
Type : D (Data file)
Physical name : E:\MSSQL\Data\ispi_live_Data.mdf
Size : 304.369 GB
Logical name : ispi_live_Log
Type : L (Log file)
Physical name : E:\MSSQL\Data\ispi_live_Log.ldf
Size : 8.779 GB
06/11/2008 17:28:05: SQL Backup process ended.
SQL Backup log file 5.3.0.178
-SQL "RESTORE DATABASE [ispi_live] FROM DISK = 'E:\MSSQL\Backup\FULL_(local)_ispi_live_20081106_154451.sqb' WITH NORECOVERY "
----------------------- PROCESSES COMPLETED SUCCESSFULLY --------------------
06/11/2008 17:28:28: Restoring ispi_live (database) from:
06/11/2008 17:28:28: E:\MSSQL\Backup\FULL_(local)_ispi_live_20081106_154451.sqb
06/11/2008 17:28:28: RESTORE DATABASE [ispi_live] FROM VIRTUAL_DEVICE = 'SQLBACKUP_D635C696-244E-491F-8789-F2D842C87388' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , NORECOVERY
Processed 16122488 pages for database 'ispi_live', file 'ispi_live_Data' on file 1.
Processed 3365 pages for database 'ispi_live', file 'ispi_live_Log' on file 1.
RESTORE DATABASE successfully processed 16125853 pages in 3002.425 seconds (43.998 MB/sec).
06/11/2008 18:18:38: SQL Backup process ended.
Sorry about the delay in getting these logs to you. Hope they help.
Paul / comments
- Community
- SQL Backup Previous Versions
- Restore Error with SQL Backup 5.3
Logs from one of the failed restore attempts as follows:
06/11/2008 13:32:23: Reading SQB file header of "E:\MSSQL\Backup\FULL_(local)_ispi_live_20081106_124235.sqb"
06/11/2008 13:32:23: B...
0 votes
