Restoring a Database

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

Moderator: SourceGear

Post Reply
Steveh24
Posts: 3
Joined: Tue Sep 30, 2008 6:50 am

Restoring a Database

Post by Steveh24 » Mon Oct 13, 2008 7:16 am

I'm new to Databases so this may appear to be a silly question

Basically I want to move Vault (4.11) from one server to another.

So far I have installed the latest version of Vault (4.13) onto the new server and I have successfully backed up the two required Databases on the current installation of Vault (sgmaster & sgvault) and copied them to the new server.

I have entered the Serial Nos. from the old Server onto the new Server, but when I go to do a restore, it says there is nothing to restore and I have since read that I need to Import them into SQL 2005, but I don't know how to do this.

My question quite simply is how do I restore my Vault Database.

Thanks in advance for any help.

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: Restoring a Database

Post by lbauer » Mon Oct 13, 2008 9:10 am

When you do a backup using the admin web client, you generally cannot restore that back up if you move Vault to another machine, since the databases are not in the same place they were on the original machine. However, you can use SQL Server backup and restore tools to restore the database. Full instructions on moving a Vault server and database here:

http://support.sourcegear.com/viewtopic.php?t=228
Linda Bauer
SourceGear
Technical Support Manager

Post Reply