Extend DPM Schema manually

In one of the project, somehow or rather, not be able to use DPM management console to extend the schema. Lots of people is looking for the manual way to extend DPM schema. There is also a time why you need to do so, to extend this feature to other trusted domain users to have end user recovery.

Steps:

Copy the following file in DPM server \Program Files\Microsoft Data Protection Manager\DPM\End User Recovery\DPMADSchemaExtension.exe. Run it in your forest. (Note: you will need to have schema admin and domain admin on the forest)

In the Enter Data Protection Manager Computer Name dialog box, type the name of the computer for which you want end-user recovery data in Active Directory Domain Services, and then click OK.

Type the DNS domain name of the DPM computer for which you want end-user recovery data in Active Directory Domain Services, and then click OK.

In the Active Directory Configuration for Data Protection Manager dialog box, click OK.

Wait for a while, it will then show you the result.

Once extended, you can then enable the end user recovery by:

In DPM Administrator Console, on the Action menu, click Options.

In the Options dialog box, on the End-user Recovery tab, select the check box for the Enable end-user recovery option, and then click OK.

Not be able to see SQL interface in DPM protection group

In one of the recent deployment, when to protect a SQL server 2005, we are not be able to see the SQL interface.

All the pre-req is met. With few hours of checking, noticed that there is one DB, which is the root cause of the problem. This DB ends with "blank".

After bringing the DB offline, we can then see the SQL interface and protect other DB.

A good experience. We are in DPM SP1, running on Windows 2008.