Forum Discussion

TheArchiveMan's avatar
TheArchiveMan
Level 3
13 years ago

Database Recovery Models

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

Enterprise Vault
Information Governance
  • JesusWept3's avatar
    JesusWept3
    13 years ago
    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

2 Replies

Sort By
  • JesusWept3's avatar
    JesusWept3
    Level 6
    13 years ago
    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
  • AndrewB's avatar
    AndrewB
    Moderator
    13 years ago

    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.