How long does SQL database recovery take?

Question

SQL Server took 1802 seconds approximately 30 minutes to recover this database. It might take longer depending on the work SQL Server to do to bring database in a consistent state after recovery. 12 мар. 2019 г.

How can I speed up SQL recovery?

To even get faster backups and restores, you could also look at these things:1Parallel backup operations.2Backup device performance.3Instant file initialization.4Data compression.5Backup compression.Optimize SQL Server Database Restore Performance

How long does it take to backup a SQL database?

Common backup speeds range approximately 1 GB per every 2 - 3 minutes. A 10 GB SQL database typically backs up in under 30 minutes.

How can I check database recovery progress in SQL Server?

SQL Server 2008 onwards, the two DMV's sys. dm_exec_requests and sys. dm_tran_database_transactions provides an insight on the different recovery states of the database startup. The other way is by executing the stored procedure “sp_readerrorlog” to get information about the progress of the database recovery.

What does it mean when a SQL database is in recovery?

After restarting SQL Server, the database moves to “In Recovery” mode. You may also see the DB in recovery state on its startup or when restoring it from backup. The database 'recovering' state means that the database performs a recovery process and will automatically come online once the process is complete.

Expert · Answer