Moving Vault to a New Server

[offwire]

Quick Background: I inherited this system as the new systems administrator and only know what i've read in the KB about this software.

We need to move this program to a new server, and from what i've read, essentially you just need to backup the DB's, uninstall the server and reinstall it, is that correct?

My second question is, when I go into add/remove programs on the server in question there is no Source Gear Vault listed anywhere. There is a SourceGear folder under Program Files which has an Admin Tools folder though. If this is normal, how am I supposed to uninstall Vault to reinstall it? And if not, what should I do to uninstall it?

Version is 5.0.3.18802 if that makes a difference.

Thanks in advance,
Jacob

[lbauer]

We need to move this program to a new server, and from what i've read, essentially you just need to backup the DB's, uninstall the server and reinstall it, is that correct?

Are you moving the Vault web service and the database or just Vault Service? If you're moving both, see this KB article:

http://support.sourcegear.com/viewtopic.php?t=228

If Vault Service is not in Add/Remove programs, try running the installer again. It should give you an uninstall option. If not, go ahead and install, then reinstall.

You can also use the Microsoft Cleanup tool to remove the installation from your machine.

http://download.microsoft.com/download/ ... sicuu2.exe

[offwire]

So I finally got a chance to move the DBs and installation to a different SQL server only to find out that it is running an older version of SQL and can't restore the DBs. I restored the DBs on the previous server and went through the installation and it all completed successfully, except that when I go to the web address now I get the following error message:

Server Error in '/VaultService' Application.
--------------------------------------------------------------------------------

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Unrecognized attribute 'type'.

Source Error:


Line 2: <configuration>
Line 3: <configSections>
Line 4: <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
Line 5: <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
Line 6: <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>


Source File: C:\inetpub\wwwroot\VaultService\web.config Line: 4


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2379; ASP.NET Version:1.1.4322.2379

And like I said previously, I don't know hardly anything about this program or how it is setup since I inherited it, help!

[lbauer]

You may need to fix IIS mappings for ASP.NET.

Vault relies on the .Net framework. This error indicates IIS may not be using the right framework version.

First, make sure you have the .NET Framework 3.5 installed.
http://www.microsoft.com/downloads/deta ... laylang=en

Then register the 2.0 framework:

1. Click Start, and then click Run.
2. In the Open text box, type cmd, and then press ENTER.
3. At the command prompt, type the following, and then press ENTER:
"%windir%\Microsoft.NET\Framework\C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe" -i

The .NET 3.5 framework is an update to 2.0, so doesn't get registered itself.

[offwire]

I had to change the command to "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe" -i but that fixed it!

Now is there any way to get past the following error I got when restoring the DB to the "new" server other than upgrading the version of SQL?

The backed-up database has on disk structure version 611. The server supports version 539 and cannot restore or upgrade this database. RESTORE FILELIST is terminating abnormally (Microsoft SQL Server, Error: 3169).

When I look at the SQL Management Studio the version it states are the following:
Current: 9.0.1399
"New": 8.0.2039

[lbauer]

You can't restore a SQL Server 2005 database to SQL Server 2000. There are some workarounds, like exporting the data and importing it, but we've never tried this with Vault and don't support it.

You either need to upgrade to SQL Server 2005, or install an instance of SQL 2005 on the same machine as the SQL Server 2000 and restore a backup to the SQL Server 2005 installation.

[offwire]

Pretty much what I figured. We are in the process of upgrading that server to sql 2005 anyways so i'll wait. Thanks again for all your help.

[lbauer]

Let me know if we can be of assistance in the future.