I have an Azure Virtual Machine hosting a SQL Server 2016 named instance. On this instance I have several DBs. Now, everyday we shutdown the virtual machine at 11.59PM and restart it at 8.00AM. The problem is that everyday I find some of the DBs in the "RECOVERY PENDING" status. This is very annoying because I must then execute a SQL script to pute the DBs in the normal status.
Do you have any cue why this is happening everyday on some (but always the same) of the DBs?
Thank you