DPM 2010 Beta : SQL Server End-User Recovery Client
As I mentioned in my previous article that DPM 2010 enable end-users to recover Databases, in order to allow end-users to recover databases DPM administrator needs to install SQL SERVER END-USER RECOVERY CLIENT and create and manage DPM roles.
In this article I will explain how to install and use SQL SERVER END-USER RECOVERY CLIENT
To install SQL Server EUR Client application, on the protected server Click Start, click Run, type %ProgramFiles%\Microsoft Data Protection Manager\SQLEur\EurClient.exe in the Open box, and then press Enter. This opens the SQL Server End-User Recovery Console (SQL EUR Console) that lists recovery jobs for SQL Server databases and provides options to start recoveries, rerun recoveries, or stop recoveries.
Before you can perform recoveries from the SQL EUR Console, you must connect to the DPM server. Click Connect to DPM Server to connect to a DPM server. You must know the name of the DPM server that you want to connect to.
After you connect to the DPM server, information is retrieved from the server about all recovery-related jobs for SQL Server databases.
By default, DPM displays recoveries done in the last 30 days. This information is automatically refreshed for current jobs. When there are no jobs running, this information is refreshed every two minutes. You can also manually refresh the information by using Refresh from the Actions menu.
SQL Server EUR Client allows you to recover SQL Server database files to a network folder or recover a database to any instance of SQL Server, however you cannot recover a database to the original instance of SQL Server directly.
To recover SQL Server databases, follow these steps:
1. In the SQL Server EUR Console, click New Recovery Job to start the Start New Recovery Job Wizard.
2. Select the SQL Server Instance Name and the Database Name that you want to recover, and then click Next.
3. Available recovery points are indicated in bold on the calendar in the recovery points section. Select the date from the calendar and the time from the drop-down list for the recovery points that you want to recover, and then click Next.
4. Specify the type of recovery you want to perform:
Recover to any instance of SQL Server. Enables you to recover SQL Server databases to an alternate instance of SQL Server that has been preconfigured by your DPM administrator. If you choose this option:
i. Click Next.
ii. Select the SQL Server Instance Name and the Recovered Database Name, and then click Next.
iii. Specify the database state and then click Next.
Copy to a network folder. You can recover SQL databases as files to any shared location where a DPM agent is installed and users have write access. If you choose this option:
i. Click Next.
ii. Select an alternate recovery point and then click Next.
iii. Specify the name of the destination server and the destination folder path to store database files during recovery.
5. Specify recovery options and then click Next.
6. On the Summary page, review the recovery settings, and then click Recover