The full text of the error in the SQL Server event log is “Failed to open the database ” configured in the session recovery object while recovering the connection”. Reason: Failed to open the explicitly specified database 'tpcc'. Reason: Failed to open the database 'tpcc' configured in the session recovery object while recovering the connection. 23:16:47.690 spid52 Setting database option SINGLE_USER to ON for database for 'tpcc'. However, some searching did find a link to what appears to be some in-depth VMWare VSAN training documentation that includes that error in some logging information, which made me wonder if it was related to the error 18456 state 38 that followed.
Even Aaron Bertrand’s list of causes of state codes for SQL Server error 18456 missed this one. Google seemed remarkably quiet on the subject of that particular state code. Summary of the question “ I have error 18456 State 73 – why?” A question asked on one of the forums today wasn’t easily answerable by Googling.
0 kommentar(er)
