Restoring Data › Restoring Data Scenarios › Best Practices - How to Recover a Stand-alone Server from a Disaster Using the Disaster Recovery Option

Best Practices - How to Recover a Stand-alone Server from a Disaster Using the Disaster Recovery Option

The following scenario describes how to leverage the Disaster Recovery Option to protect a Arcserve Backup server that is hosting SQL Server databases.

Server Specifications

The Arcserve Backup server is configured as follows:

• The Arcserve Stand-alone Server installation option is installed on the server.
• The Arcserve database is hosted using Microsoft SQL Server 2008 Express Edition.
• The stand-alone server is hosting various Microsoft SQL Server databases.

Software Specifications

The following applications are installed on the Arcserve Backup server:

• Microsoft Windows Server
• Microsoft SQL Server
• Microsoft SQL Server 2008 Express Edition as the Arcserve Backup database
• Arcserve Backup for Windows
• Arcserve Backup Client Agent for Windows
• Arcserve Backup Agent for Microsoft SQL Server
• Arcserve Backup Disaster Recovery Option

  Note: Microsoft SQL Server and Microsoft SQL Server 2008 Express reside on the same node. The Arcserve Backup installation routine installed the Microsoft SQL Server 2008 Express application.

Use the following guidelines to recover a Arcserve Backup server that is hosting SQL Server databases from a disaster:

1. During the backup operation, ensure that you do not status the SQL Server and SQL Server 2008 Express instances as offline.
2. Perform a full backup of the machine. The backup should be successful.
3. Create the Disaster Recovery Boot Kit.

   Note: For information about creating a Disaster Recovery Boot Kit, Disaster Recovery Option Guide.

4. Perform Disaster Recovery restore. The restore should be successful.

   During the restore operation, the Disaster Recovery Option recovers the master and model databases in the Arcserve Backup database (Microsoft SQL 2008 Express).

5. When prompted, restart the Arcserve Backup server.

   After you restart the Arcserve Backup server, the disaster recovery process continues recovering the Arcserve Backup database. After the Arcserve Backup database is recovered, you can start Arcserve Backup normally.

6. Restore the disaster recovery element sessions for the SQL Server database instances.

   Note: For more information, see the Agent for Microsoft SQL Server Guide.

7. Restart the SQL instances.
8. Restore the data to each of the SQL instances.