Need to move the Vault SQL DB to a different SQL Server

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

Moderator: SourceGear

Post Reply
RichardWest
Posts: 5
Joined: Tue Apr 13, 2010 10:43 am

Need to move the Vault SQL DB to a different SQL Server

Post by RichardWest » Fri Sep 03, 2010 7:37 am

Hello,

I have Vault 5.0.3.18802 installed on a stand alone server. The SQL database is stored on a seperate server dedicated to SQL.

I need to move the Vault database from the current SQL Server (SQL 2005) to a new SQL Server running 2008.

Can someone describe the steps to preform this migration from Vaults perspective? I'm confortable in backing up and restoring the SQL database itself. I'm looking for guidance on where Vault stores this SQL server connection information that I will need to update.

Is this just a matter of reinstalling the Vault Server software and pointing to the new SQL server?

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: Need to move the Vault SQL DB to a different SQL Server

Post by Beth » Fri Sep 03, 2010 7:53 am

Here's a KB article on moving just the Vault database: http://support.sourcegear.com/viewtopic.php?t=924.

Here's a link to the KB article index in case you need additional information: http://support.sourcegear.com/viewtopic.php?f=13&t=792.
Beth Kieler
SourceGear Technical Support

Post Reply