2 Replies Latest reply: Mar 9, 2010 8:49 AM by Koteswara Rao Kasani RSS

SQL Data Base restore error

Koteswara Rao Kasani
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

Actions