Jim Metcalf
asked on
stop a database from serving requests... but not the instance
I want to take a database offline. there are mulitiple databases on this sql instance. I don't want to detach the database and i don't want the other databases in the sql instance to be affected at all.
the database that needs to go offline needs to not allow users to connect at all
i have sql 2008 and another server running sql 2012.
how can i accomplish this?
Thank you
the database that needs to go offline needs to not allow users to connect at all
i have sql 2008 and another server running sql 2012.
how can i accomplish this?
Thank you
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.