Facing a major problem while performing restoration of my mssql DB

[Former Member]

Dear Experts,

I am facing a major problem while performing restoration of my mssql DB. The situation is like

1. I have successfully take full and transactional log backup in a external device using MSSQL Server Managemnt Studio.

Backup was successfully completed as per MSSQL Server Managemnt Studio message.

2. Try to restore the same using MSSQL Server Managemnt Studio. It is showing the following error

System.Data.SqlClient.SqlError: RESTORE cannot process database <DB_SID> because 
it is in use by this session. It is recommended that the master database be used when 
performing this operation.

I have followed the guidelines specified in the link

[SAP Help Link for Restoring the <SAPSID> Backup from a Device |http://help.sap.com/saphelp_nw70/helpdata/en/f2/31ad56810c11d288ec0000e8200722/frameset.htm]

But everytime I am getting the same error message. I have checked with all options but there

was no resolutions. Kindly advise me in this regard.

Thanks and Regards,

Partha

[Former Member]

Answered

[former_member524429]

???

[ken_halvorsen2]

Were you using the <sid>adm user when you logged onto the server? That might cuase that problem.

[Former Member]

http://social.msdn.microsoft.com/Forums/en-CA/sqltools/thread/37ee8e24-7aaa-472b-861a-fc0cc513338a

hope it helps