KB labels


Ticket Product Version

Ticket Category

Ticket Assignee


Hot Fixes

Published Fixes
Your Arcserve Support User Profile
First Name:
Last Name:
email:
Phone:
Company:*
Customer Type:
Language:

Country:
Region:

Time zone:
Follow

arcserve-KB : How to change the arcserve Backup Database from Microsoft SQL Express to Microsoft SQL Server.

Last Update: 2015-12-15 22:11:27 UTC

CA ARCSERVE BACKUP FOR WINDOWS COMMON: 12.5
Last Modified Date:    05/08/2009
Document ID:    TEC487911
Tech Document
Title:  How to change the CA ARCserve Backup Database from Microsoft SQL Express to Microsoft SQL Server.

Description:

Changing the CA ARCserve Backup Database from Microsoft SQL Express to Microsoft SQL Server.

Solution

Using the Server Configuration Wizard, you can configure Microsoft SQL Server as the CA ARCserve Backup database.

Before you configure Microsoft SQL Server as the CA ARCserve Backup database, the following considerations apply:

  • Microsoft SQL Server must be installed on the system hosting the CA ARCserve Backup database before you start this task.
  • After you configure CA ARCserve Backup to use Microsoft SQL Server as the ARCserve database, the Server Configuration Wizard opens a command utility labeled exptosql.exe that migrates the core and detail tables from the Microsoft SQL Server 2005 Express database to the newly configured Microsoft SQL Server database.
  • You can use this procedure to move the CA ARCserve Backup Microsoft SQL Server database to a different server.

Configure Microsoft SQL Server as the CA ARCserve Backup database

  1. From the Windows Start menu, click Start, select All Programs, CA, ARCserve Backup, and click Server Configuration Wizard.
  2. Click the Select database option and click Next.
  3. Follow the on-screen instructions to complete the configuration.

    Note: If you protect data that contains Unicode-based characters from East Asian languages (for example, JIS2004) you must enable SQL collation to ensure that you can search and sort the data. To do this, click Language Support Options on the Select Database Installation Path dialog and follow the on-screen instructions to complete the configuration.

    Figure 1
  4. After the configuration is complete, the Server Configuration Wizard opens a command line window, starts exptosql.exe, and migrates the SQL Server 2005 Express core and detail tables to the new SQL Server database.

    If exptosql.exe does not start, open a command line window and start exptosql.exe.

    Note: By default, exptosql.exe is installed in the following directory:

    C:\Program Files\CA\ARCserve Backup

    Execute the following commands:
    1. exptosql.exe core

      This is a required step. The core argument lets you migrate the core tables from the SQL Server 2005 Express database to the SQL Server database.

      Important! You must execute this command immediately after the SQL Server configuration is complete.
    2. exptosql.exe detail

      This is an optional step. The detail argument lets you migrate the detail tables from the SQL Server 2005 Express database to the SQL Server database. You can execute this command, at any time, after the core migration process is complete.

      Note: Depending on the size of the SQL Server 2005 Express database, the detail table migration process can require a significant amount of time to complete.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments