Return
-
Title
Which type of restore is the fastest: RECOVERY, NORECOVERY, STANDBY? -
Description
One of the factors that may affect restore speed is the database state after a restore (RECOVERY, NORECOVERY, STANDBY).When you use theSTANDBYoption, an undo file is included. The UNDO file contains the undo actions resulting from uncommitted transactions, in the case of a ROLLBACK. The more uncommitted transactions, the larger the UNDO file created during the restore process, and subsequently the longer the restore will take, in some cases a large database can cause restores to be quite lengthy.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.