Re: SQL 2008 Restore to different server (90 Views)
Frequent Advisor
Stefano Colombo
Posts: 122
Registered: ‎11-14-2002
Message 1 of 2 (124 Views)

SQL 2008 Restore to different server

We are trying to restore several DB to a "test" server .

The destination server has been installed from scratch and we are able to backup DB from it .

The destination server has been configrued with the "default" instance while the production server has a named instance .

When trying to restore we selected the options

- different client

- different instance

Then we tried a restore of the Production DB to it but it istantly fails with the following error



From: ""  Time: 16/10/2013 11:14:02

Restore session 2013/10/16-21 started.


From: ""  Time: 16/10/2013 11:14:02

OB2BAR application on "" disconnected.



                      Session failed!


Please use plain text.
HP Expert
Posts: 1,185
Registered: ‎08-14-2013
Message 2 of 2 (90 Views)

Re: SQL 2008 Restore to different server

Please check the server ' ', open the Task Manager, and get a list of running processes.  This error may occur if a previous OB2BAR process is hung


On the server '', check to see if any of these processes are running






or, on the server '', from the MS-DOS prompt, you can just run the command 'tasklist', output to a 'text' file, and attach it to this posting, let me see if I can see anything

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation