PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Configure files and filegroup restore settings

When you configure Microsoft SQL Server restores with the Microsoft app agent for Application Direct SSMS plug-in, you change the default destination folders of the database files (.mdf and .ndf) and log files (.ldf) on the Database Restore > Files/Filegroups page.

1. From the left panel, click Files/Filegroups.

   The Files/Filegroups page appears as shown in the following figure.

   

2. Under Filegroup Options, to display the corresponding database files of the databases that you have selected on the General page, from the Select Filegroup to restore list, select one of the following options:

   • All Files: Displays the database files of all the selected databases.

   • PRIMARY: Displays the database files of the selected databases that belong to the PRIMARY filegroup only.

   • Custom filegroup name: Displays the database files of the selected databases that belong to the selected custom filegroup name only. In the figure, the custom filegroup names are sec and third.

3. Under Relocation Options, to change the destination restore paths, perform one of the following action sequences:
   • To change the destination paths of all of the data and log files, perform the following steps:
     1. Select Relocate all files to folder.
     2. Click the Data file folder browse button to specify a location for the data files, or click inside the field to type the folder path.
     3. Click the Log file folder browse button to specify a location for the log files, or click inside the field to type the folder path.
   • To change the destination path for each individual data or log file, perform one of the following actions in the files table:
     • To browse for a destination path, click the browse button to the right of each data or log file. A window appears where you can browse and select the file path.
     • To type a new destination path, in the Restore As column, click the appropriate cell and type a destination path. If the path does not exist, a dialog box appears asking if you want to create the folder.
   NOTE:The settings under Relocation Options are disabled if you have selected the Restore backups as files option on the General page.
4. To start the restore operation, click Run.