I am trying to detach a MS SQL DB and for some odd reason that option is grayed out. I have never seen this before. Does anybody have a solution to why?
It's either a permissions issue or a system db issue. You can't detach the system dbs. You have to use the Alter Database command if you want to move the files, for all but the Master DB, and the Master DB you have to do something funky with to move.
If you're trying to do something else with the system dbs other than move the files, you're out of luck. Sorry.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.