Re: Disable DB without deleting data

2012-07-20 Thread Kirk Hoganson
Would this keep permissions intact? I need something that would make it easy to automatically restore the database including any custom permissions? Thanks again for the input, Kirk On 07/20/2012 12:16 PM, Rick James wrote: No. RENAME DATABASE does not exist. It may have something to do wit

Disable DB without deleting data

2012-07-19 Thread Kirk Hoganson
I need to find an easy way to make a database unavailable without deleting the data, so that it could be easily and quickly restored if necessary, without impacting the availability of the other databases. Something like moving the databases subdirectory to a different directory, or the "detac