Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products

PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

PDF

Configure files and filegroup restore settings

When you configure SQL 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.

About this task

All settings on the Files/Filegroups page are optional.
NOTE Settings on the Files/Filegroups page are disabled when you configure a restore to a remote server, including changing the restore path.

Steps

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

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

    Figure 1. Application Direct - Database Restore-Files page
    Application Direct - Database Restore-Files page
  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.

  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\