Re: SQL 2008 Restore to different server (194 Views)
Frequent Advisor
Posts: 129
Registered: ‎11-14-2002
Message 1 of 2 (228 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!


HP Expert
Posts: 1,704
Registered: ‎08-14-2013
Message 2 of 2 (194 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

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.