2 extracting the database files to folders – Acronis Backup for Windows Server Essentials - User Guide User Manual

Page 310

Advertising
background image

310

Copyright © Acronis International GmbH, 2002-2014

Active Restore supports the following backup locations:

A local folder on the machine where the recovery is performed (except optical disks).

Acronis Secure Zone.

A network share.

To use Active Restore, enable it on the Recover data page (p. 131) under How to recover.

The recovery process

1. If the recovery task includes the master database, it is recovered first. During this process, the

instance is in the single-user mode and, therefore, users cannot connect to it. After the database
is recovered, the software restarts the instance.

2. The agent starts the recovery of other databases. Multiple databases are recovered in parallel.

First, the databases are in the Restoring state and users have no access to them. After a short
time, users obtain the read-write or read-only access to the databases, depending on the state
specified in the recovery task settings.
Details. The Acronis Active Restore drivers intercept user queries. The data required to service
the queries is recovered with the highest priority; everything else is recovered in the background.
As a result, users can access their data even though the databases are not yet recovered.

3. After the recovery is completed, the databases are reattached. This takes less than a minute.

Because the servicing of requests is performed simultaneously with recovery, the database operation
can slow down even if recovery priority (p. 163) in the recovery options is set to Low. Although the
database downtime is minimal, there may be reduced performance during recovery.

12.4.2 Extracting the database files to folders

SQL database files and transaction logs can be extracted from a single-pass backup to a folder you
specify. This can be useful if you need to recover databases to a machine where Agent for SQL is not
installed, or you need to extract data for data mining, audit or further processing by third party tools.

To extract database files

On the Recover data page:

1. Under What to recover, click Select data and select the databases.
2. If the console is connected to the management server, select a registered machine where Agent

for SQL is installed. Otherwise, skip this step.

3. Select Extract the database files to folders.
4. In Target folder, specify the destination folder where the database files will be saved.

Details. If you select more than one database, files of each database will be extracted to a
separate folder within the folder you specify. If the destination folder already contains a file of a
database with the same name as the selected database, the database files will be extracted to
subfolder <instance name>\<database name>.

5. Specify other settings of the recovery task as appropriate.

Once the extraction is completed, you can attach the database to a SQL Server instance. For
instructions on how to do this by using SQL Server Management Studio, see the "Attaching SQL
Server databases" (p. 291) section.

Advertising
This manual is related to the following products: