v4.1.4: Can two vault servers point to the same db?

[kha]

I am trying to install my new Vault Server on the new separated physical box, and I don't want to get rid of the old one yet because I want to keep it just in case the new one doesn't work right, I still have the old one to fail back to. Of course, I want to keep the SQL server the same, the SQL server is on another separated stand-alone box.

I remember when we install the Vault Server, it looks for sgvaultuser username and sgmaster db from the SQL server. I don't remember exactly how it reacts if sgmaster db is existing on the SQL server. So, my question is that, is it workable the way I want to do (above proposal)? Will it cause any conflict?

[lbauer]

We don't support using two Vault servers against the same SQL Server database at the same time, as this can cause unexpected behavior.

However, you can install Vault on the new machine, pointing it at the SQL Server location and it will upgrade the database (if you're upgrading) and also configure the Vault server connection/user login to SQL Server.

If you need to go back to the old box, then reinstall Vault on the old machine pointing it to SQL Server location.

Note: If you are upgrading, then if you go back to the old Vault Server machine, you'll need to install the upgraded version, as an older version of Vault can't work with a newer version of the database.

[kha]

Two Vault servers can't (or shouldn't) commit transactions to the same SQL Server database at the same time, as this can cause database corruption.
However, you can install Vault on the new machine, pointing it at the SQL Server location and it will upgrade the database (if you're upgrading) and also configure the Vault server connection/user login to SQL Server.
If you need to go back to the old box, then reinstall Vault on the old machine pointing it to SQL Server location.
Note: If you are upgrading, then if you go back to the old Vault Server machine, you'll need to install the upgraded version, as an older version of Vault can't work with a newer version of the database.

I should have mention that I won't have two vault servers operate at the same time. Before we have the new Vault Server operates, we would have to stop the Vault Server IIS. We will use the same Vault Server version for both old and new Vault Server. I will leave everything untouch on SQL server, and just add another Vault server box (same version) and shut down the old Vault server box before turnning on the new Vault Server. Is that still ok?

[lbauer]

Yes. As I said earlier, installing Vault on the new server and pointing to the database location should take care of any configuration issues.