Take database offline how long

Learn More. Visit the Upgrade Resource Center. Learn more. Professional Premier Premier Enterprise. Choose what best fits your environment and budget to get the most out of your software. Get priority call queuing and escalation to an advanced team of support specialist. Premier Support Premier Enterprise Support. Your SolarWinds products come with a secret weapon. Orange Matter. View Orange Matter. LogicalRead Blog.

Read the Blog. Toggle SideBar. Success Center. Select your Preferred Language from the below list. Network Management. Publishing Information First Published Date. In my case the developers had a production main website for a very well known bank pointing at a database lebelled OLD — ZZ9. Put it in single user mode, and then try again.

Ajay KMike - the only connection I have is open to the Master database, not the database I'm trying to take offline. Rudy Rudy 2, 1 1 gold badge 19 19 silver badges 23 23 bronze badges. Sage advice - thank you - but in this case the data is expendable as it's a development database that is being restored to. Armand G. RamenNoodle RamenNoodle 31 4 4 bronze badges. Same with me. Dan Dan 5, 20 20 gold badges 82 82 silver badges bronze badges. I tried all the suggestions below and nothing worked.

Result: The window was stuck on executing. Viraj A Viraj A 83 5 5 bronze badges. Steve Woods Steve Woods 3 3 silver badges 8 8 bronze badges. Re-open Options and turn read-only back off Now try renaming the database or taking it offline. You may wish to check if any services are currently utilizing the database.

Jonathan Jonathan 4, 2 2 gold badges 19 19 silver badges 36 36 bronze badges. Brett Drake Brett Drake 2 2 silver badges 11 11 bronze badges. In my case i stopped Tomcat server. Java Main Java Main 1, 12 12 silver badges 17 17 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.

Email Required, but never shown. The Overflow Blog. Podcast Explaining the semiconductor shortage, and how it might end. Does ES6 make JavaScript frameworks obsolete? Featured on Meta. I prefer taking database offline before dropping or deleting them. This is to avoid any mistakes or loosing data prematurely. After keeping the database offline for a month or so, I usually drop them from the server.

Below are couple of simple methods to take the database offline.