Find when a specific database went offline and the reason for same and when did it recover back.
All I know there is a SCOM alert set for the server and I got a notification as Database is offline and later when I checked I found it as online. So, I want to check at what time it went offline and how and when did it come online?
Best Answer
At minimum, please check sql logs, for example, if I purposely take a db offline using
I can see in SQL Server log, the following message