SQL Data Base restore error

Kotesh Kasani Mar 9, 2010 6:24 AM

Currently Being Moderated

Dear Colleagues,

I am trying to restore my database "SID" and its failing with the following error...

Error:

Restore failed for server 'SAP-Hostname'. (Microsoft.SqlServer.Smo)

Additional information

System.Data.Sqlclient.SqlError: RESTORE cannot process database 'MIB' because it is in use by this session. It is recommended that the master darabase be used when performing this operation (Microsoft.SqlServer.Smo)

If any of you come across this issue, please help out to resolve the same.

Thanks,

Kotesh

Re: SQL Data Base restore error

Bhavik G. Shroff Mar 9, 2010 7:35 AM (in response to Kotesh Kasani)

Currently Being Moderated

Hi,

Please refer[ this useful link|http://social.msdn.microsoft.com/Forums/en-CA/sqltools/thread/37ee8e24-7aaa-472b-861a-fc0cc513338a], which is describing the same symptom and suggesting the solution "changing the user default database to the master db resolved the issue".

Also, I hope you have selected "overwrite the existing database" while restoring DB.

Regards,
Bhavik G. Shroff
Report Abuse

Like (0)
- Re: SQL Data Base restore error
  
  Kotesh Kasani Mar 9, 2010 8:49 AM (in response to Bhavik G. Shroff)
  
  Currently Being Moderated
  
  Hi Bhavik,
  
  Thanks for your posting, Its help me
  
  Regards,
  Kotesh
  
  Report Abuse
  
  Like (0)

Go to original post