Specify Recovery Target Locations
Applies To: System Center Data Protection Manager 2010
Use this page to specify one or more recovery target locations and file paths to restrict where users of this DPM role can recover the files for their specified databases. You do not need to specify recovery target locations or paths for users of this DPM role to recover their SQL Server databases files. If you do not restrict the recovery target locations, at the time of recovery, the users can recover database files to any location for which they have write permission. However, users cannot overwrite the original database files, and the DPM Self-Service Recovery Tool (SSRT) for SQL Server blocks them if they attempt to do so. If you do not want to specify recovery target locations for users, leave the Allow users to recover the databases to another instance of SQL Server check box clear, and then click Next.
Specify Recovery Target Locations page
To restrict the locations to which users can recover SQL Server database files, select the Allow users to recover the databases to another instance of SQL Server check box, click Add, and then type an instance of SQL Server in the SQL Server Instance column, and optionally type a path in the Recovered File Path column where users of this role can recover their SQL Server database files, or to enable users to recover to any path on the instance, press the TAB key, and then press the Spacebar to clear the text in the Recovered File Path column.
If all of the users for this role are SQL Server database administrators, you might want to enable them to recovery their database files to any location on an instance of SQL Server. However, if the users are not SQL Server administrators, you might want to restrict the locations to which they can recover the database files so that they do not affect the functioning of other SQL Server databases.
Note
You can specify multiple instances of SQL Server.
To remove a recovery target location, select the instance in the SQL Server Instance list, and then click Remove.
After you have provided all required information, click Next.