RESTORE cannot process database ” because it is in use by this session. It is recommended that the master database be used when performing this operation
If you get this, try restoring using the master (like it says).
use master
restore database DatabaseName FROM DISK = ‘c:\Path\To\My\Bak.bak’
Boosh.
Thursday Jul 29th