Error 3701

I am trying to detach a database so I can move the log file to another drive there is no more room for both  mdf and ldf. I am getting an error message that says

Error 3701: cannot detach the database it is currently in use.

I have push the clear button and get the same error
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
>cannot detach the database it is currently in use.

as the message says: at least 1 more session is currently connected to that database.
usually, the enterprise manager/ Sql studio itself is still connected to the db.
so, ensure there are no more sessions to the db, for example by closing the +dbname in the object explorer, and then just right-click the db to come to the detach menu. ...
arahmingAuthor Commented:
Wow I never would have thought that thanks it worked
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.