From hibernation, all sessions become disconnected

ahdung

please fix this, thank you.
----------------------------------
OS: Windows server 2008 R2 x64 with SP1
SqlPrompt: 9.4.15.8960 (maybe whole 9.x, I remember 8.x not have this problem)

Russell D

I doubt very much that we can, given that the sessions will timeout. Can you send a verbose log in - one that contains a hibernation session - though so I can at least see if there's any useful debug information?

ahdung

How to get such a log?

Russell D

See https://documentation.red-gate.com/sp9/troubleshooting/finding-the-sql-prompt-log-files.

And just to clarify what I'm looking for is enabling verbose logging, performing a hibernate, re-awaken, then re-loading SSMS and seeing this disconnected sessions in Prompt, then getting the log.