Acronis^® Recovery™ for MS SQL Server

Create a Disaster Recovery Plan

You want to make sure that your crucial databases can be restored as quickly as possible. For that purpose a comprehensible disaster recovery plan should be created, which will help even a person without DBA knowledge to restore damaged databases in a time-efficient manner.

Step-by-step Solution

Step 1:

Launch the Disaster Recovery Plan Creation wizard by clicking on the Disaster Recovery Plan operation icon in the main workspace.

Step 2:

In the first step of the wizard specify the Define databases for which you want to receive the plan each time it is updated option to define databases, for which you want to generate the Disaster Recovery Plan each time any changes occur in it. The updated version of the plan will be automatically sent to the e-mail addresses you specify.

Step 3:

Select the databases for which you want to obtain the disaster recovery plan.

Step 4:

Specify the e-mail account that will be used for sending the disaster recovery plan. Provide the e-mail address to which the plan will be sent and the outgoing SMTP server name. You can specify several e-mail addresses separating them by commas. A user name and a password might also be needed if the SMTP server requires authentication. You can check if the settings are correct by clicking the Send test E-Mail message button.

Step 5:

The final stage of the Disaster Recovery Plan Creation wizard is the summary window, displaying the list of operations that will be performed. Click Finish to schedule receipt of the disaster recovery plan after each update.