Managing the Database and Reporting › Specify a Arcserve Backup Database Application › Configure Microsoft SQL Server as the Arcserve Backup Database

Configure Microsoft SQL Server as the Arcserve Backup Database

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

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

• Microsoft SQL Server must be installed on the system hosting the Arcserve Backup database before you start this task.
• After you configure 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 2008 Express database to the newly configured Microsoft SQL Server database.
• You can use this procedure to move the Arcserve Backup Microsoft SQL Server database to a different server.

Note: For more information about using Microsoft SQL Server as the Arcserve Backup database, see Using Microsoft SQL Server as the Arcserve Backup Database.

To configure Microsoft SQL Server as the Arcserve Backup database

1. From the Windows Start menu, click Start, select All Programs, CA, ARCserve Backup, and click Server Configuration Wizard.

   The Server Configuration Wizard opens.

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.

   

4. After the configuration is complete, the Server Configuration Wizard opens a command line window, starts exptosql.exe, and migrates the SQL Server 2008 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 2008 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 2008 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 2008 Express database, the detail table migration process can require a significant amount of time to complete.