Backup Strategy Questions

davenovak · Post by **davenovak** » Fri Feb 09, 2007 4:02 pm

Do you have recommendations for doing automated backups of the Vault database? I would like to back up incrementally each day and in full each week, minimum. Any suggestions? Which Vault services need to come offline to make this work?

lbauer · Post by **lbauer** » Sat Feb 10, 2007 7:29 pm

You can set this up using SQL Server backup tools, either using Enterprise Manager/Management Studio, or via T-SQL scripts. If you want incremental backups, then you should enable Full recovery mode, so that the transaction log will be used for the incremental backups. Note that in Full recovery mode, the transaction log can get rather large.

Some useful links:

Backup instructions for SQL Server 2005

http://msdn2.microsoft.com/en-us/library/ms187591.aspx

Backup and recovery strategies:
http://www.microsoft.com/technet/prodte ... t.mspx#EQE

davenovak · Post by **davenovak** » Mon Feb 12, 2007 4:27 pm

Thanks -- this is helpful information on the backup.

I am using the "simple" recovery mode. Do I need to shut down the vault service during the backup? If so, how best can this be accomplished?

lbauer · Post by **lbauer** » Mon Feb 12, 2007 4:33 pm

It's best to not have any connections during the backup. You can stop Vault by iisreset \stop, which stops IIS, or by stopping the Vault Application pool in IIS if you have IIS 6.

davenovak · Post by **davenovak** » Mon Feb 12, 2007 4:50 pm

Good deal -- I'll just stop the Vault application pool. Thanks.