Managing the Database and Reporting › How to Protect the Arcserve Backup Database › Restore the Arcserve Backup Database (Different Domain)

Restore the Arcserve Backup Database (Different Domain)

This section describes how to restore the Arcserve Backup database and the database was backed up using an Arcserve server that resides in a different Arcserve Backup domain. You can restore the Arcserve database in the following scenarios:

• The Arcserve database is functional
• The Arcserve database is not functional and the instance hosting the Arcserve database is functional

In these scenarios you can restore the Arcserve database using the Backup Manager on the system that backed up the Arcserve database.

Important! You cannot restore the Arcserve database while there are jobs in progress. If a job tries to access the Arcserve database while the restore is in progress, the job will fail.

To restore the Arcserve Backup database that was backed up in a different Arcserve Backup domain

1. Stop all Arcserve Backup services running on the primary and the member servers in the domain using the cstop batch file.

   Note: For more information, see Stop and Start All Arcserve Backup Services.

2. Log in to the Arcserve domain containing the backup data for the database that you want to restore.

   Open the Restore Manager window, click the Source tab, select the Restore by Tree method, expand the Windows Systems object, and browse to the primary server associated with the database that you want to restore.

   Expand the server that you want to restore.

   Based on the type of database that is running in your environment, select the following database objects:

   Microsoft SQL Server 2014 Express

   Expand the server object and select the following objects:

   • Arcserve Backup Database object
   • Microsoft SQL Server Disaster Recovery Elements

   Note: If Arcserve Backup is installed in a cluster-aware environment, you must status the Microsoft SQL Server 2014 Express service in maintenance mode before you submit the restore job.

   Microsoft SQL Server

   Expand the server object, expand the Microsoft SQL Server object, and submit individual restore jobs for the following objects:

   • System databases: [master], [msdb], and [model]
   • asdb database object

3. Click the Options toolbar button.

   The Global Options dialog opens.

4. Select the Operation tab, click the Disable Database Recording option, and click OK.

   The database restore options are applied.

5. Click the Destination tab and select the Restore files to their original location option.

   Important! If the Arcserve Backup database is a Microsoft SQL Server 2014 Express instance and Arcserve Backup is installed in a cluster-aware environment, you must place the SQL Server service in cluster maintenance mode before submitting the restore job.

   Click the Submit on the toolbar to submit the restore job.

   The Submit Job dialog opens.

   Note: If there are jobs in progress, Arcserve Backup prompts you to restore the Arcserve database to a different location. If you cannot restore the Arcserve database to a different location, allow all jobs in progress to complete, and then restore the Arcserve database.

6. Complete the fields on the Submit Job dialog and click OK.

   After the restore job is complete, complete the following tasks:

   1. Start all services on the primary and member servers in the domain using the cstart command.

      Note: For more information, see Stop and Start All Arcserve Backup Services.

   2. Using the Merge utility, merge all backup media.
   3. Perform a full backup of the Arcserve database.

Be aware of the following behaviors:

• After you restore the Arcserve Backup database, the job history for the Database Protection Job will indicate that the job is incomplete and the Activity Log will indicate that the job is in progress with an Unknown status. This behavior occurs because the data for the Activity Log and the Database Protection Job is stored in the Arcserve Backup database and the data was incomplete while backup was in progress.

  In addition, the status of the Database Protection Job (Done) will be the same as it was before you submitted the restore job. This behavior occurs because the Job Queue will obtain the status of the Database Protection Job from the job scripts rather than from the Arcserve Backup database.

• The first job that you run after you recover the Arcserve Backup database appears in the Job Status Manager with the same Job ID as the restore job for the Arcserve Backup database. This behavior occurs because the Job ID assigned to the Arcserve Backup database restore job is lost after you restore the Arcserve Backup database.
• Arcserve Backup may attempt to purge data that had already been purged from the staging device when you restore the Arcserve Backup database in a disk staging environment. You will receive a warning message, however, the purge job will complete successfully.