Online Backup - Migration of Client Database
from MSDE to Microsoft  SQL 2005

 

Online Backup Service - Upgrading from MSDE to Microsoft SQL 2005

Solution 1 - Upgrade the existing MSDE instance to SQL 2005.

1. Run a Daily Admin that will backup the databases to the online backup datacenters.

2. Stop SecuriData’s Service Manager.

3. Upgrade the MSDE instance to SQL 2005. If this is successful continue with Step 4, otherwise Solution 2.

4. Start SecuriData’s Online Backup Service Manager.

5. Test the connection with SecuriData’s datacenter by running a Daily Admin to dump the Client databases and back them up to datacenter.

Solution 2 - Install an instance of MS SQL 2005 and migrate.

1. Run a Daily Admin that will backup the databases to the online backup datacenter.

2. Stop SecuriData’s Online Backup Service Manager.

3. Install a SQL 2005 instance. Backup all three Client databases and restore them in the new MS SQL 2005 instance with MS SQL 2005 tools.

4. Reconfigure the Registry Keys for SecuriData’s Online Backup Software in order to use the restored databases from the SQL 2005 instance.

* In 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 by modifying the value DependOnService from “MSSQL$MSDE_INSTANCE” to “MSSQLServer”.

5. Start SecuriData’s Online Backup Service Manager.

6. Test the connection with the datacenter by running a Daily Admin to dump the Client databases and back them up to online backup datacenter.