cancel
Showing results for 
Search instead for 
Did you mean: 

Database Recovery Models

TheArchiveMan
Level 3

For the EV SQL databases, should they be in Simple or Full recovery mode for best performance? Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

JesusWept3
Level 6
Partner Accredited Certified
Performance wise setting to simple is the best way to go as it takes load off of IO and CPU (and dependi on the storage network as well) However depending on how you do backups of the vault stores, you cannot do point in time restores and replays of the transaction logs with Simple logging If you do multiple snapshots per day for your vault store partition backups then i'd recommend keepin it to full If you do like differential/incremental on weeknights and fulls on the weekend then I'd recommend simple
https://www.linkedin.com/in/alex-allen-turl-07370146

View solution in original post

2 REPLIES 2

JesusWept3
Level 6
Partner Accredited Certified
Performance wise setting to simple is the best way to go as it takes load off of IO and CPU (and dependi on the storage network as well) However depending on how you do backups of the vault stores, you cannot do point in time restores and replays of the transaction logs with Simple logging If you do multiple snapshots per day for your vault store partition backups then i'd recommend keepin it to full If you do like differential/incremental on weeknights and fulls on the weekend then I'd recommend simple
https://www.linkedin.com/in/alex-allen-turl-07370146

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

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.