The following options are available if you want to migrate a DS-Client database from SQL Server Express to Microsoft SQL Server Full Version. You need to migrate if you reach the limit of the SQL Server Express database (4 GB for SQL 2005 Express and 10 GB limit of the SQL Express 2008 & up), or if you plan a significant increase to the number of files protected with this DS-Client.

o "Option 1 - Migrate by importing DB files to a new Instance"

o "Option 2 - Migrate by upgrading the DB Instance"

Option 1 - Migrate by importing DB files to a new Instance

1. Run a Daily Admin. This will backup the DS-Client databases to the DS-System.

2. Stop DS-Client Service.

3. Backup (dump) all DS-Client databases (dsclient, dsdelta, dslanfiles and any expand databases e.g. expand0001, expand0002, etc.).

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 a new MS SQL Server instance (separate purchase required).

5. Obtain MS SQL Server Management Studio Express (which can be downloaded from http://www.microsoft.com).

Using the Studio Express tools, restore all three DS-Client databases (from the dump files in step 3) to the new MS SQL Server instance.

6. Reconfigure the Registry Keys on the DS-Client computer, in order to use the new MS SQL Server instance (where you have just restored the DS-Client databases).

In the Registry

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\DS-Client:

- Provide the path for the database:

Parameters\Database=\\MACHINE_NAME\INSTANCE_NAME\dsclient

- Change the Dependency for DS-Client service by modifying the value DependOnService from "MSSQL$SQLEXPRESS" to "MSSQLServer".

7. Start DS-Client Service.

8. Test the connection with the DS-System by running a Daily Admin. Verify there are no errors in the Activity Log.

Option 2 - Migrate by upgrading the DB Instance

1. Run a Daily Admin. This will backup the DS-Client databases to the DS-System.

2. Stop DS-Client Service.

3. Obtain a new MS SQL Server instance (separate purchase required).

4. Running the MS SQL Server installation over the SQL Server Express instance is NOT sufficient to perform a successful upgrade.

o You must follow the instructions for installation using the skuupgrade parameter that can be found at:

https://msdn2.microsoft.com/en-us/library/ms144259.aspx#skuupgrade

5. After the upgrade is successful, start the MS SQL Server instance.

6. Start DS-Client service.

7. Test the connection with the DS-System by running a Daily Admin. Verify there are no errors in the Activity Log.