Administering the Backup Server › Manage Arcserve Servers Using the Server Configuration Wizard › Data Migration Limitations in a Arcserve Backup Domain

Data Migration Limitations in a Arcserve Backup Domain

The Server Configuration Wizard lets you define the roles of the servers in an Arcserve domain and specify the application that you want to use to host the Arcserve database instance.

Arcserve Backup lets you migrate Arcserve database instance data as described by the following scenarios.

Scenario 1:

You exchange the roles of the primary server and a member server in an Arcserve domain. You can successfully migrate data under the following conditions:

• The original primary server hosted the Arcserve database instance using Microsoft SQL Server 2014 Express Edition and new primary server is hosting the Arcserve database instance using Microsoft SQL Server 2014 Express Edition.
• The original primary server hosted the Arcserve database instance using Microsoft SQL Server and new primary server is hosting the Arcserve database instance using Microsoft SQL Server.

Important! Arcserve Backup does not support data migration when the original primary server hosted the Arcserve database with Microsoft SQL Server and the new primary is hosting the Arcserve database with Microsoft SQL Server 2014 Express Edition.

To accomplish a successful data migration, complete the following steps:

1. From the primary server that you want to demote, back up the Arcserve database using the Database Protection Job.

   Note: Allow the Database Protection Job to finish before continuing.

2. Promote the member server to a primary server.
3. Demote the original primary server and allow it to join new primary server's domain.
4. From the Agent Restore Options dialog on the new primary server, specify the following options:
   • Use current Arcserve database as original location.
   • Preserve current Arcserve domain memberships.
5. Restore the original Arcserve database to the new primary server.

Scenario 2:

You modify the application hosting the Arcserve database from Microsoft SQL Server 2014 Express Edition to Microsoft SQL Server.

Note: This scenario applies to Arcserve primary server and Arcserve stand-alone server installations.

To accomplish a successful data migration, complete the following steps.

1. Run the Server Configuration Wizard on the primary or stand-alone server and specify the Select database option.

   After the database modification and configuration process is complete, the Server Configuration Wizard prompts you to migrate the data from the old database instance to the new database instance.

2. Migrate the data from the Microsoft SQL Server 2014 Express Edition instance to the Microsoft SQL Server instance.
3. Uninstall Agent for Arcserve Database.
4. Reinstall the Agent for Arcserve Database to create the new database instance using the following executable:

   <Arcserve_HOME>\Packages\ASDBSQLAgent\SQLAgentRmtInst.exe
   

5. Uninstall the ARCSERVE_DB instance of Microsoft SQL Server 2014 Express Edition.

Scenario 3:

You exchange the roles of the primary server and a member server in an Arcserve domain. The original primary server hosted the Arcserve database instance using Microsoft SQL Server 2014 Express Edition and new primary server is hosting the Arcserve database instance using Microsoft SQL Server.

Note: In this scenario you must convert the Arcserve database from a Microsoft SQL Server 2014 Express Edition instance to a Microsoft SQL Server instance on the primary server that you want to demote before you back up the Arcserve database instance.

To accomplish a successful data migration, complete the following steps:

1. Run the Server Configuration Wizard on the primary server and specify the Select database option.

   After the database modification and configuration process is complete, the Server Configuration Wizard prompts you to migrate the data from the old database instance to the new database instance.

2. Migrate the data from the Microsoft SQL Server 2014 Express Edition instance to the Microsoft SQL Server instance.
3. From the primary server that you want to demote, back up the Arcserve database using the Database Protection Job.

   Note: Allow the Database Protection Job to finish before continuing.

4. Promote the member server to a primary server.
5. Demote the original primary server and allow it to join new primary server's domain.
6. From the Agent Restore Options dialog on the new primary server, specify the following options:
   • Use current ASDB as original location.
   • Preserve current Arcserve domain memberships.
7. Restore the original Arcserve database to the new primary server.