Backup Mode


I've been asked by my SQL DBA, which recovery mode to set on the database, Simple Recovery Mode or Full Recovery Mode.

Any sugesstions.

Hello Quintin,

Usual policies apply here. You should have your system with Full Recovery Model in your production environment. In your other systems it's really up to you, but we suggest that you use simple recovery mode on development and QA environments.

Please be aware that full recovery mode can generate a lot of logs and will need specific maintenance steps to ensure you flush the transaction log from time to time.

Ricardo Silva
Thanks Ricardo. It makes sense.