07-06-2012 08:59 AM
For the EV SQL databases, should they be in Simple or Full recovery mode for best performance? Thanks
Solved! Go to Solution.
07-06-2012 10:03 AM
07-06-2012 10:03 AM
07-09-2012 10:42 AM
To add to what JW said, recovery model has to do with how the log is reused and how you restore the database in case of a failure. If you need to be able to restore to point-of-failure, then you need full recovery model and log backups. If it's acceptable to lose everything back to the last full backup, simple recovery is sufficient. But even in simple recovery mode, SQL writes to the transaction log so I doubt that you would notice a difference in performance with EV.