Moving Vault 8.0.1.30299 to a new DB server

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
veenasrinivas
Posts: 1
Joined: Mon Jul 09, 2018 10:26 am

Moving Vault 8.0.1.30299 to a new DB server

Post by veenasrinivas » Mon Jul 09, 2018 10:34 am

I am in the process of decommissioning a SQL server which hosts the Source Gear Vault databases.
I will be moving the following databases to another DB server.

sgdragnet
sgmaster
sgnotify
sgvault
sgvaultindex

Once I move them to the new DB server, how to do I point the application to the new server?
The Application is running on a different box .

Tonya
Posts: 866
Joined: Thu Jan 20, 2005 1:47 pm
Location: SourceGear

Re: Moving Vault 8.0.1.30299 to a new DB server

Post by Tonya » Mon Jul 09, 2018 1:47 pm

The following knowledge base article will assist you with the move of your Vault database to a new machine:

viewtopic.php?t=228

Thanks,

Tonya Nunn
SourceGear

Lofton
Posts: 1
Joined: Thu Jul 19, 2018 4:05 am

Re: Moving Vault 8.0.1.30299 to a new DB server

Post by Lofton » Thu Jul 26, 2018 8:33 am

Hi Tonya, is this applicable to any version of the Vault?
I think Leanbean is the best choice for quick results.

Tonya
Posts: 866
Joined: Thu Jan 20, 2005 1:47 pm
Location: SourceGear

Re: Moving Vault 8.0.1.30299 to a new DB server

Post by Tonya » Thu Jul 26, 2018 10:31 am

The KB article lists specific steps according to your Vault version:

For Vault 4.x and 5.x you will need to move the sgmaster and sgvault databases. For Fortress\VaultPro, you will also move the sgdragnet database.

For Vault 6.x, 7.x, 8.x, 9.x and above, move the sgmaster, sgvault, sgvaultindex and sgnotify databases. For VaultPro 6.x and above, you will also move the sgdragnet database.

Tonya

Post Reply