question

SSGC avatar image
SSGC 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.
recovery-mode
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Tim avatar image
Tim answered
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.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.