DS-Client Database Migration (from SQL Server Express version to SQL Server FULL version)
Creation Date: November 28, 2007
Revision Date: September 20, 2012
Product: DS‑Client (Windows)
Introduction
NOTE: This article uses Microsoft SQL Server 2005 as an example, however, this procedure is also applicable for higher versions (i.e. SQL Server 2008, 2008 R2, 2012, and up).
The following options are available if you want to migrate a DS-Client database from SQL Server 2005 Express to Microsoft SQL Server 2005. You need to migrate if you reach the 4GB limit of the SQL Server 2005 Express database, or if you plan a significant increase to the number of files protected with this DS-Client.
Option 1 - Migrate by importing DB files to a new Instance
1. Run a Daily Admin. This will back up the DS-Client databases to the DS-System.
2. Stop DS-Client Service.
3. Back up (dump) all three DS-Client databases (dsclient, dsdelta and dslanfiles). You can also use the dump files created by the Daily Admin in step 1 (if the DS-Client is configured to keep them in the DS-Client Buffer).
4. Install Microsoft SQL Server 2005 (separate purchase required).
5. Install Microsoft SQL Server 2005 Management Studio Express (download from http://www.microsoft.com or which comes with the Microsoft SQL Server 2005 you purchased).
6. Using the Studio Express tools, restore all three DS-Client databases (from the dump files in step 3) to the new Microsoft SQL Server 2005 instance.
7. Reconfigure the Registry Keys on the DS-Client computer to use the new Microsoft SQL Server 2005 instance (where you have restored the DS-Client databases).
a) In Registry
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\DS-Client:
Provide the path for the database:
Parameters\Database=\\MACHINE_NAME\INSTANCE_NAME\dsclient
b) Change the Dependency for DS-Client service by modifying the value DependOnService from “MSSQL$SQLEXPRESS” to “MSSQLServer”.
8. Start DS-Client Service.
9. Run Daily Admin to test the connection with the DS-System. Verify there are no errors in the Activity Log.
Option 2 - Migrate by upgrading the DB Instance
1. Run a Daily Admin. This will back up the DS-Client databases to the DS‑System.
2. Stop DS-Client Service.
3. Install Microsoft SQL Server 2005 (separate purchase required).
Running the Microsoft SQL Server 2005 installation over the SQL Server 2005 Express instance is NOT sufficient to perform a successful upgrade.
• Follow the instructions for installation using the skuupgrade parameter that can be found at:
https://msdn2.microsoft.com/en-us/library/ms144259.aspx#skuupgrade
4. After a successful upgrade, start Microsoft SQL Server 2005.
5. Start DS-Client service.
6. Run Daily Admin to test the connection with the DS-System. Verify there are no errors in the Activity Log.