Configure files and filegroup restore settings
When you configure SQL Server restore 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. All settings on the Files/Filegroups page are optional.
- From the left panel, click Files/Filegroups.
- The Files/Filegroups page appears.
- 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.
- 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:
- Select Relocate all files to folder.
- 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.
- 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.
- To start the restore operation, click Run.