ACCELERATED DATABASE RECOVERY

Bonjour a tous

Est ce que l'activation de l'option ADR

Code:

---

ALTER DATABASE xxxxxx SET ACCELERATED_DATABASE_RECOVERY = ON;

---

Accélérer t'il les opérations de ROOLback ?

Merci

OUI !

Extrait de la doc :
Instantaneous transaction rollback
With ADR, transaction rollback is instantaneous, irrespective of the time that the transaction has been active or the number of updates that has performed.

https://docs.microsoft.com/en-us/azu...?view=azuresql

A +

Bonjour a vous

J'en parle dans ce tuto ;)

https://www.youtube.com/watch?v=poFP...?v=poFPwkV7lDk