Previous Topic: How to Migrate the Backend Database and Upgrade from Arcserve UDP 5.0 with SQL 2005 to Arcserve UDP 6.0Next Topic: Migrate Arcserve UDP 5.0 with SQL Server 2005 to Arcserve UDP 6.0 with SQL Server Express Edition After Upgrade

Upgrading to Arcserve UDP Version 6.0 › How to Migrate the Backend Database and Upgrade from Arcserve UDP 5.0 with SQL 2005 to Arcserve UDP 6.0 › Migrate Arcserve UDP 5.0 with SQL Server 2005 to Arcserve UDP 6.0 with Supported SQL Server Before Upgrade

Migrate Arcserve UDP 5.0 with SQL Server 2005 to Arcserve UDP 6.0 with Supported SQL Server Before Upgrade

Before you upgrade to Arcserve UDP Version 6.0, you can migrate the database to a supported database.

Migration Consideration

Ensure that jobs are not running in the Arcserve UDP 5.0 environment. Stop the data store, if required.

Follow these steps to migrate Arcserve UDP 5.0 with SQL Server 2005 to Arcserve UDP 6.0 before the upgrade:

  1. Stop the Arcserve Console Management Service.

    Stop Console management service interface

  2. Back up the backend database before the upgrade.
    1. Back up the Arcserve Database with SQL Server Management Studio.

      Back up SQL DB

    2. On the Back Up Database dialog, configure the backup destination, and click OK.

      Configure backup destination on the Database

  3. Migrate the backed up older database data to the newly installed SQL Server.

    Restore the database that you have backed up in the previous step to the newly installed Arcserve UDP Database SQL server. Check the Compatibility Matrix to select the supported Database version.

    1. From the SQL Management Studio, right-click the database and click Restore Database.

      Restore database in SQL Studio\

    2. Verify the Source - Device is same as the previous backup destination and add the backed up database file.

      Device source dialog

    3. Click OK.
  4. Start Arcserve UDP Management Service in Windows Services Console.
  5. Connect to the restored database in Arcserve UDP Version 5.0 Console.
    1. Log in to the Arcserve UDP Version 5.0 Console.
    2. From the configuration tab, click Database Configuration.
    3. Provide the new database information, including SQL Server Machine Name, Instance, Port, and Authentication.
    4. Click the Test button.

      Database configuration in Console

    5. After the test connection is successfully established, click Save.
    6. Verify all the plans in the Version 5.0 Console work properly after connecting to the restored database with the supported SQL Server.
  6. Upgrade to Arcserve UDP Version 6.0 from the previous release.

    Note: For more information, see How to Upgrade to Arcserve UDP 6.0 from a Previous Release.