none
Automatically add new SQL data sources on secondary server RRS feed

  • Question

  • 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

    Chris


    Chris

    Wednesday, April 22, 2015 6:27 PM

Answers

  • 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."


    Thursday, April 23, 2015 11:59 AM

All replies

  • 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."


    Thursday, April 23, 2015 11:59 AM
  • 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.



    Chris

    Thursday, April 23, 2015 2:24 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

    Thursday, April 23, 2015 5:59 PM