Recovery Model for All Vault Databases

[MarkCR]

Greetings:
I am a new user of Vault. I have just successfully installed the server (Pro) and, if history repeats itself, I will be the administrator and maintainer of this thing. The first thing our network administrator wanted to know was the recovery model that these databases would be employing. This ultimately determines how big those LOG files are going to grow. So, I've got THREE databases here that have been made by the installer: sgvault, sgmaster and sgdragnet.

I searched for and read all of the topics I could find in the knowledge base that refer to "recovery model". The consensus seems to be that "Basic" is fine for a recovery model but I never see mention of whether this applies to ALL THREE of the databases or not.

I should mention that the network files (including our database files) are subject to a full backup each weekend and nightly incremental backups.

Thank you,
Mark Roberts
Toronto

[lbauer]

Either Full or Simple recovery model can work for all three databases. It really depends on your system policies. In the event of a failure, do you want to restore transactions that have been logged in the SQL Server transaction log since the last backup?

The downside is that the transaction log can get very large before the next time you backup the database and truncate the log.

Simple backup keeps the transaction log small, as transactions are immediately committed to the database, rather than being kept in the log. However, if you have a failure and need to restore, you lose everything between the failure and the last good backup.