Getting Started With CA ARCserve Central Protection Manager › Re-create the CA ARCserve Central Protection Manager Database

Re-create the CA ARCserve Central Protection Manager Database

For various reasons, you may want to re-create the CA ARCserve Central Protection Manager database. For example, your current database consumes more than 10 GB of data. The following procedure describes how to re-create the CA ARCserve Central Protection Manager database. The procedure applies to Microsoft SQL Server and Microsoft SQL Server Express Edition databases.

Important! When you delete the CA ARCserve Central Protection Manager database, all current data is lost.

To re-create the CA ARCserve Central Protection Manager database

1. Open Microsoft SQL Server Management Studio Express and log in to the ARCserve_APP instance.

   Note: If Microsoft SQL Server Management Studio Express is not installed on the CA ARCserve Central Protection Manager server, you can download the utility from the Microsoft Download Center.

2. Right-click ARCAppDB and click Delete on the pop-up menu.

   The Delete Object dialog opens.

   

3. On the Delete Object dialog, click the Close existing connections options and click OK.

   The Delete Object dialog closes and the CA ARCserve Central Protection Manager database is deleted.

4. Open CA ARCserve Central Protection Manager and click Configuration on the Navigation bar.

   The configuration options display.

5. Click Database Configuration.

   The database options appear.

6. Verify that that the values specified in the following fields are correct:
   • SQL Server Machine Name--Specify the name of the server that hosts the SQL Server instance.
   • SQL Server Instance--Specify the name of the SQL Server instance.
7. (Optional) Complete the following fields:
   • SQL Server port--Specify the port number for this instance or enable the Auto detect option.
   • Choose the Authentication Mode--Windows Authentication Mode is the default selection.

     Note: Selecting SQL Server and Windows Authentication Mode enables the User Name and Password fields.

   • Specify the Database Connection Pool values--For Max and Min Connections, enter a value from 1 through 99.
8. Click Test to establish a connection to the database.
9. Click Save.

CA ARCserve Central Protection Manager re-creates the database. The name of the database instance is ARCAppDB.