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 (single-pass) 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 (single-pass) 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" section.