none
Slow replica creation RRS feed

Answers

  • Hi,

    SQL 2008 support 8 parallel backups per instance, so create 8 different PG's (distribute the SQL DB's across these 8 PG's) so that 8 Backup jobs run in parallel. This should help reducing the overall backup time (because 8 jobs will happen simultaneously).


    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, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Friday, March 16, 2012 1:46 AM
    Moderator

All replies

  • Hi,

    SQL 2008 support 8 parallel backups per instance, so create 8 different PG's (distribute the SQL DB's across these 8 PG's) so that 8 Backup jobs run in parallel. This should help reducing the overall backup time (because 8 jobs will happen simultaneously).


    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, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Friday, March 16, 2012 1:46 AM
    Moderator
  • Thanks Mike.

    Can we modify this setting?

    I have notice in the registry:

    HKLM\software\microsoft\microsoft data protection manager\configuration\MaxParalleIncrementalJobs\SQL = 8

    Can we change that?

    Is there documentation for the registry settings for DPM?

    Friday, March 16, 2012 1:05 PM
  • Hi,

    I don't have any documentation on that key, however SQL 2008 only supports 8 parallel backups per instance,  so if you attempt to perform more than that, I'm not sure how SQL is going to fail / react. 


    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, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Friday, March 16, 2012 2:15 PM
    Moderator