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?