SQL SERVER – Offline, Detach and Drop – Differences – SQL in Sixty Seconds #103


 

During the recent consulting engagement of Comprehensive Database Performance Health Check, I was asked by my client, if I can help them understand the difference between database status like Offline, Detach and Drop. It was very important to differences between them as they can lead to data losses.

Warning: Do not try any of the suggestion discussed in this video on your production server. Try them out on your Development environment with utmost care as it is possible that you may lose the data permanently.

Let us understand the difference between Offline, Detach and Drop with the help of a SQL in