Using SQL Server 2008 R2 SQLEXPRESS (SQL Server 10.50.1600), I backed up a small database to file but when I tried to restore it, I got the following message even when logged I as sa and running the restore from the master database ?
should I detach the database prior to attempting a restore ?
Error message :
System.Data.SqlClient.SqlError : RESTORE cannot process database 'Midas1' because it is in use by this session.
It is recommended that the master database be used when performingthis operation.