asked
sql2016 database in recovery but still can query
Hi Expert, I see a case I don't know why. I suddenly see a sql2016 server database in recovery, I didn't do anything and looks no one do anything on this database. server logs show this database 'starting up database xxx', 'CHECKDB for database 'xxx' finished without errors on 2013-11-01 05:29:27.320 (local time). This is an informational message only; no user action is required.'. at same time I still can query the table and if i remote login to server, i open SSMS there and connect to server, it not show the database is in recovery. it is very strange.
Chances are when you connected to the instance, the database was still coming online and going through crash recovery. My thought is that the database finished and came online, however your connection still shows in-recovery. If you refresh the database list in SSMS it will likely show everything normal.
18 People are following this question.
