某次重启SQL SERVER数据库服务器以后,数据库无法使用(显示“In recovery”)
可以通过windows event log查看到它的恢复进度
1.打开 Event viewer
2.找到Windows log —— Application —— Source:MSSQLSERVER
3.Filter current log —— <all event ids>替换为3450 —— OK
即可看到类似以下信息,恢复的预计时间
Recovery of database 'DBXXXX' (13) is 3%% complete (approximately 60030 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.