Forum Discussion
SQL Server 2019 – Repeated Recovery Mode and Backup Failure After Server Shutdown
Hello, We are currently using SQL Server 2019 Standard Edition in our company. Recently, our server experienced a complete shutdown due to a lightning strike. After the incident, one of our database...
I believe you must do a DBCC CHECKDB to evaluate if there is a problem with the database
if it comes back with no error, probably the DB is going to recovery because there are long running DML sessions running when server get restarted so it requires long time to recover. you can consider to enable Accelerated Database Recovery (ADR) on that specific database https://learn.microsoft.com/en-us/sql/relational-databases/accelerated-database-recovery-concepts?view=sql-server-ver17