offline Archives - SQLServerGeeks

SQL Server / SQL Server Accidental DBA Series

Detach or take offline in SQL Server

March 19, 2015December 20, 2019 - by SQL Geek - Leave a Comment

Detach or take offline both causes a database to be inaccessible to users. The difference is that detach deletes database metadata from SQL Server i.e. database file information, status information and …

SQL Server

SQL Server Database States – simple talk but not simpler

September 13, 2013September 11, 2014 - by Kanchan Bhattacharyya - Leave a Comment

Dear Friends, Very recently while imparting training to junior DBAs someone from them asked me what are the different states of a database and how they can move into each stage? …