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

Comments

Sort by recent activity
Eddie, I performed an xcopy of the backup from the source server to the target and tried another restore which has failed again. Couple of things to mention, the DB is now showing as stuck in Restoring Mode. When I got to the drive where the MDF is, it is now showing the full size of the MDF file which is 146GB, so looks like it has completed most of the restore, but just not able to complete Log TestDBServer: Restore - Failed =========================== Restoring full backup - Failed ------------------------------ This operation failed with errors. Restoring TESTDatabase (database) from: V:\Transfer\TESTDatabase.sqb Thread 0 error: Failed to service command.  Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Thread 1 error: Failed to service command.  Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Thread 2 error: Failed to service command.  Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Thread 3 error: Failed to service command.  Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Thread 4 error: Failed to service command.  Error code: -2139684860 Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) SQL error 3013: RESTORE DATABASE is terminating abnormally. SQL error 3183: RESTORE detected an error on page (22:347356) in database "TESTDatabase" as read from the backup set. SQL Backup exit code: 790 SQL error code: 3183 Updating SQL Server information - Pending ----------------------------------------- Operation pending. / comments
  1. Community
  2. SQL Backup
  3. Error While Restoring a Backup on a different Server
Eddie,I performed an xcopy of the backup from the source server to the target and tried another restore which has failed again.Couple of things to mention, the DB is now showing as stuck in Restori...
0 votes
Eddie, Thanks for the update, we have been using these 2 servers for many months and a lot of other DB servers for many years, copying DB's between them using Windows file explorer. I tried a different DB this morning, which was dramatically smaller to be fair, less than 1Gb compared to the one mentioned above which has a backup file of 6GB. The DB backup this morning was performed on the same servers listed above and it restored 1st time with no issues, do you think it could be size related? Cheers / comments
  1. Community
  2. SQL Backup
  3. Error While Restoring a Backup on a different Server
Eddie,Thanks for the update, we have been using these 2 servers for many months and a lot of other DB servers for many years, copying DB's between them using Windows file explorer. I tried a differ...
0 votes
Robyn, Thanks for the update, that worked a treat. Regards John / comments
  1. Community
  2. SQL Backup
  3. SQL Backup 10 - How do I Export Registered Servers
Robyn,Thanks for the update, that worked a treat.RegardsJohn
0 votes
Total activity
6
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2