Specifications

A.6 Using the Disaster Recovery Plan to restore

databases

Scenario

The business owner wants to be sure that the databases can be restored at any time, even

in case the database administrator is not available for any reason. For that purpose, a

comprehensive Disaster Recovery Plan should be created, which will help a person without

DBA knowledge restore damaged databases.

Acronis solution

While creating a backup task, the database administrator should specify a Disaster Recovery

Plan option, so that it would be sent to the business owner’s email. In case of a disaster, the

staff can restore databases according to the instructions contained in the Disaster Recovery

Plan.

A.7 Restore databases immediately using rolling

snapshots (for Microsoft SQL Server 2005

Enterprise only)

Scenario

Database administrator must be able to restore databases in the shortest amount of time.

Acronis solution

While creating a backup task, the database administrator should specify the option Create

rolling snapshots immediately after differential backup is created and set the

required number of snapshots to store.

To restore from a rolling snapshot the database administrator should use Microsoft SQL

Server tools.

A.8 Manual backup (before crucial changes in

databases)

Scenario

The company is preparing to make extensive changes to the databases. To avoid possible

loss, the databases must be backed up.

Acronis solution

The database administrator can use previously created backup tasks and start them

manually from the Acronis Recovery for MS SQL Server Management Console.

Another option is to start a new task for creating full backups. The administrator can specify

it so that it will only be executed manually.