sql restore error database in use

Server: Msg 3101, Level 16, State 2, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

this was the error when i tried to use restore command with replace on an existing database. i checked the activity monitor, there is a process for the database that has status 'sleeping'. could that be the problem?
LVL 1
sqlserverdbaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
chapmandewConnect With a Mentor Commented:
Yes!  Kill that spid....if might be yours though.  If so, switch your db context and try again.
0
All Courses

From novice to tech pro — start learning today.