question

phkaushik avatar image
phkaushik asked

detaching database

Hi While detaching the database in sql server 2008 i am facing the error "users can killed only processes" My Databases is in Restricted mode too.. Gaurav Kaushik
database
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
Do you mean Error 6107 - "Only user processes can be killed" ?
1 Like 1 ·

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
I'm not familiar with that exact error message (is it a translation issue?). But, it sounds like, despite being in restricted user mode, there are other connections to the database, possibly even you. Ensure that all users are disconnected with the database prior to attempting to detach it. Also ensure that you don't have connection to it through SSMS or any other tool.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.