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
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.

PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Configure file destination settings

View and change the default destination folders of the database files that are data files (.mdf and .ndf) and log files (.ldf) from the Database Restore > Files page.

About this task

All settings on the Files page are optional.

File information on the Files page is shown only when a single database and a backup version is selected on the General page. If you select multiple databases or do not select a backup version, file information does not appear and the databases are restored to the latest backup.

NOTE:

If you are restoring the backup to an alternate instance, the data and log files are automatically relocated to the target Microsoft SQL Server instance default data and log path. You can change the file destination settings on the Files page.

Ensure that the Microsoft SQL Server administrative account for the target Microsoft SQL Server instance has access to the selected path so that it can access the database files once they are mounted.

Steps

  1. From the left panel, click Files.

    The Files page appears as shown in the following figure.

    Figure 1. VM Direct: Database Restore Files page
    VM Direct: Database Restore Files page
    The table on the page displays the source locations of the database files.
  2. 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.
  3. To change the destination path at the file group level, perform one of the following actions in the table:
    • To browse for a destination path, click the browse button to the right of each file group.

      A window appears where you can browse and select the file path.

    • To type a new destination path, in the Restore To 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:Ensure that the destination paths are not root drives, for example, E:\.

Next steps

Specify the PowerProtect Data Manager server details and additional restore options on the Options page.


Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  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: <>()\