If you've encountered a situation where SQL Server begins recovery after a failure, you might observe databases in the "in Recovery" mode. This indicates that SQL Server is either rolling back incomplete transactions or applying changes recorded in the log but not yet written to the data file. You should wait till the recovery finishes and database will become accesable again.
The "in Recovery" mode can also appear when initiating a restore operation with the "WITH RECOVERY" option.
Comments
Post a Comment