How can we help you today? How can we help you today?
phowlett
Activity overview Badges (0) Posts (2) Comments (1)

Activity overview

Latest activity by phowlett

Can you restore a backup from SQL Server 2008 to 2005?
  1. Community
  2. SQL Backup Previous Versions
I assume you would be able to take a backup taken from SQL Server 2005 and restore that backup onto SQL Server 2008. However, is it possible with Redgate Backup to restore in the other direction -...
1 follower 1 comment 0 votes
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
  1. Community
  2. SQL Backup Previous Versions
  3. 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
Restore Error with SQL Backup 5.3
  1. Community
  2. SQL Backup Previous Versions
I have received the following error when attempting to restore a full backup using SQL backup 5.3: MSSQL2K5-MIR01: Restore - Failed ================================ Restoring full backup - Failed ...
2 followers 2 comments 0 votes
Total activity
4
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1