Hi there.. I have found an issue that I cannot resolve.

We have two DPM servers set up to be secondary servers for each other.. it has worked well for months and I was very happy with the setup.

What I had not realized was if a new SQL database was created and was picked up by the local DPM server, the secondary server did not pick up the new data source.

Is there a way to get a secondary server to refresh the list of data sources it should be backing up without having to manually updating the Protection Group once a week.

Many thanks

Hi,

Have you attempted the following? From the secondary DPM Server modify the protection group in question.

1. From the select group members step expand the needed SQL server.
2. Select the SQL instance (ensure the check box is checked off next to the SQL instance) then right click.
3. Now click on Turn on auto protection (Figure 1) to enable.

 Figure 1:Enabling SQL auto protection from Secondary DPM Server.

 Figure 2:After SQL auto protection is enabled.

Also the below may assist.

https://technet.microsoft.com/en-us/library/hh758042.aspx

**************

Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Dwayne Jackson II. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights."

• Edited by Dwayne Jackson IIMicrosoft employee 19 hours 40 minutes ago
• Marked as answer by Data Lib 17 hours 21 minutes ago

Dwayne,

You are a star... that is just what I needed.. is it documented anywhere as I have looked for a solution for quite a while.

Thank you for your prompt reply.. very appreciated.

Hi,

Have you attempted the following? From the secondary DPM Server modify the protection group in question.

1. From the select group members step expand the needed SQL server.
2. Select the SQL instance (ensure the check box is checked off next to the SQL instance) then right click.
3. Now click on Turn on auto protection (Figure 1) to enable.

 Figure 1:Enabling SQL auto protection from Secondary DPM Server.

 Figure 2:After SQL auto protection is enabled.

Also the below may assist.

https://technet.microsoft.com/en-us/library/hh758042.aspx

**************

Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Dwayne Jackson II. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights."

• Edited by Dwayne Jackson IIMicrosoft employee Thursday, April 23, 2015 12:01 PM
• Marked as answer by Data Lib Thursday, April 23, 2015 2:20 PM

Hi,

Have you attempted the following? From the secondary DPM Server modify the protection group in question.

1. From the select group members step expand the needed SQL server.
2. Select the SQL instance (ensure the check box is checked off next to the SQL instance) then right click.
3. Now click on Turn on auto protection (Figure 1) to enable.

 Figure 1:Enabling SQL auto protection from Secondary DPM Server.

 Figure 2:After SQL auto protection is enabled.

Also the below may assist.

https://technet.microsoft.com/en-us/library/hh758042.aspx

**************

Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Dwayne Jackson II. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights."

• Edited by Dwayne Jackson IIMicrosoft employee Thursday, April 23, 2015 12:01 PM
• Marked as answer by Data Lib Thursday, April 23, 2015 2:20 PM

Hi,

Have you attempted the following? From the secondary DPM Server modify the protection group in question.

1. From the select group members step expand the needed SQL server.
2. Select the SQL instance (ensure the check box is checked off next to the SQL instance) then right click.
3. Now click on Turn on auto protection (Figure 1) to enable.

 Figure 1:Enabling SQL auto protection from Secondary DPM Server.

 Figure 2:After SQL auto protection is enabled.

Also the below may assist.

https://technet.microsoft.com/en-us/library/hh758042.aspx

**************

Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Dwayne Jackson II. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights."

• Edited by Dwayne Jackson IIMicrosoft employee Thursday, April 23, 2015 12:01 PM
• Marked as answer by Data Lib Thursday, April 23, 2015 2:20 PM

Happy to assist. As documentation was lacking I will work with the DPM team to have a blog created for the DPM team blog noted below. Thank you for the feedback.

Data Protection Manager Team blog: http://blogs.technet.com/dpm/

**************

Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards,Dwayne Jackson II. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights