Building a vault server for backup!

[peace]

I'd to build vault server for backup, because current I have a lot of repository. beside I have 60 licenses for clients in local and outbound.
In order to If primary server is downed then we can access backup server for working.
Current, My primary vault server is version 3.05 (OS: win2003, Database: SQL server 2000)
I show my plan - in my opinion: (Please let me know your idea)

- Install backup server (OS: win2003, Database: SQL server 2000)
- Backup and restore database
- Install vault server – version 3.1
- Everyting work ok.
- After that make schedule to relicate vault database bewteen primary and backup server
So is it ok?
Please show me how to build backup server to work simultaneously in details.

Thanks,
-Peace.

[lbauer]

It's not possible do simultaneous updates from one Vault database to another. Vault doesn't support replication with the current Vault database schema. We use encryption, which prevents the trigger from being published as part of SQL Server replication.

One suggestion is to make frequent backups of your production database. Then, if the primary server is down, you can quickly restore a copy of your database to the backup server.

See these steps for moving the database to a different SQL Server machine:
http://support.sourcegear.com/viewtopic.php?t=924

Be sure that the version of Vault on the backup machine is the same version as the version you're using for production or the database may be incompatible.

Another option is to restore the database to the new location and re-install Vault on the backup machine.