Move the Arcserve Backup Database to a Different System or Instance

Managing the Database and Reporting › Specify an Arcserve Backup Database Application › Move the Arcserve Backup Database to a Different System or Instance

Move the Arcserve Backup Database to a Different System or Instance

Use the Server Configuration Wizard to move the Arcserve Backup database to a different system or instance.

Note: This option only applies to Microsoft SQL Server installations.

Before you move the Arcserve Backup database to a different system or instance, be aware of the following considerations:

The Server Configuration Wizard lets you change your current Microsoft SQL Server configuration to the following types of configurations:
- Cluster-aware
- Remote
- Local
To access the new SQL Server installation, you must specify a method of authentication. You can use one of the following authentication methods:
- Windows security
- SQL Server security
For remote SQL Server installations that use SQL Server authentication, you must provide the Login ID and Password for the Remote Server Administrator Account.

To move the Arcserve Backup database to a different system or instance

From the Windows Start menu, click Start, select All Programs, CA, ARCserve Backup, and click Server Configuration Wizard.
The Server Configuration Wizard opens.
Select the Select Database option and click Next.
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.

After the configuration is complete, you must install the Arcserve Backup database protection agent on the system hosting the SQL Server database.
To install the Arcserve database protection agent, do one of the following:
- If the SQL Server database is installed on the Arcserve Backup primary server, open Windows Explorer and browse to the following directory:
```
C:\Program Files\CA\ARCserve Backup\Packages\ASDBSQLAgent
```
- If the SQL server database is not installed on the Arcserve Backup primary server, open Windows Explorer and browse to the following directory:
```
C:\Program Files\CA\ARCserve Backup\Packages\ASDBSQLAgent
```
  Copy the contents of the ASDBSQLAgent directory to any location on the system hosting the SQL Server database.
In the ASDBSQLAgent directory, double-click the following file:
```
SQLAgentRmtInst.exe
```
The Arcserve Backup Agent for SQL Setup dialog appears.
Complete the following fields, as required, for your installation:
- SQL Instance Name
  Specify the name of the SQL instance that you want to protect.
- Auth Mode
  Specify the authentication mode that Arcserve Backup will use to communicate with and protect the database.
  
  If you specify SQL Authentication as the authentication mode, complete the following fields:
  - SQL SA Name
    Specify the SQL system account name.
  - SQL SA Password
    Specify the SQL system account password.
Click Install and follow the on-screen instructions to complete the installation.