Online Backup - Migration of Client Database
from MSDE to Microsoft SQL
- Online Backup Media Presentations
- What is Online Backup
- Online Backup & Firewalls
- Online Backup Data Encryption
- Online Backup e-Notifications
- Restore File System Backups
- Online Backup Installation & Small Business Server2003
- Online Backup Microsoft Exchange Server
- Online Backup for Exchange, Lotus Notes and Novell GroupWise (Brick Level)
- Online Backup for Microsoft SQL Server
- Online Backup for Oracle Database Server
- Online Backup for Netware
- Migrate Service from MSDE to SQL 2005
- Online Backup - Service Account Logon
- Online Backup - Bare Metal Restore
Migration of SecuriData's Online Backup Client DB from MSDE to SQL 2005
The following options are available if you want to migrate the SecuriData’s online backup “Client” database from Microsoft MSDE to Microsoft SQL. You need to migrate if you reach the 2GB limit of the MSDE database, or if you plan a significant increase to the number of files protected with SecuriData’s online backup software.
1. "Solution 1 - Upgrade the existing MSDE instance to SQL 2005 or higher."
2. "Solution 2 - Install an instance of MS SQL 2005 and then migrate."
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.