I am trying to restore a SQL Server 2008 backup and am getting the following error:
RESTORE cannot process database because it is in use by this session.
ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: RESTORE cannot process database 'database_name' because it is in use by this session. It is recommended that the master database be used when performing this operation. (Microsoft.SqlServer.Smo)
Any idea what is wrong?