I currently run into an issue, that a SQL Server Database has the state 'recovery pending' every morning. No one has started a database recovery, the server itself decides to do it.
The recovery process gets stuck and the SQL Server stops working, as its memory limit is reached.
Temporarily, I can resolve it by restarting the
MSSQLSERVER process and then taking the database offline and back online. However, as this seems to be happening every day now, this is an unacceptable workaround.
I am eager to know:
- What are the possible reasons, that a SQL Server automatically starts such an automated restore process
- Are there any Logs / Events I can look for, to find the reason.
- How can I solve it :)
Any help or hint will be highly appreciated.
Update: Database was in
recovery pending, not in
restore pending . The SSMS is installed in german language and didn't show me the english status.