This is because the user database has an active connection with your current session. Try changing database connection to a different database by using USE DATABASE. Like...
USE master RESTORE DATABASE MYDATABASE FROM DISK ='C:\DBBackup.bak' WITH REPLACE
edit | flag
Gokul A Answered on: Feb 04, 2012 at 6:43AM
Post your Answer
Welcome to Ask Amoeba! This is 100% free and interactive site for sharing professional Questions and Answers, Opensource projects, Interview questions. Learners, beginners, Experts stop and share your knowledge and ideas!