none
DPM 2K12 - Protection group planification problem RRS feed

  • Question

  • Hi,

    I use a protection group to protect a SQL Server with several databases (7 at the moment) in automatic mode (new databases automatically added).

    My problem is on the short term planification, and here are the settings: 4h replica synchronization + recovery point at 7PM every day.

    The issue is that on the seven databases, only 2 are synchronized every 4h according to the task log (4AM, 8AM, 12PM, 4PM, 8PM).

    Only the backup scheduled at 7PM takes the 7 databases with no problem.

    Why the synchronization only use 2 databases and the 5 others are left alone ? (there is activity on the 7 databases)

    Thursday, January 7, 2016 10:11 PM

Answers

  • Hi anahimself,

    Please start by verifing that the SQL-DBs are set to Recovery Model: Full. You can do this via SQL Management Studio.
    If the DBs are configured with Recovery Model: Simple, DPM will not be able to perform the backup of the logs.

    EDIT: Remeber to stop and re-add the SQL-DBs if you change the Recovery Model. Even thought you have auto-protection enabled, DPM will not know that the Recovery Model has changed.

    Kind Regards
    Markus


    • Edited by MarkusEliasson Friday, January 8, 2016 11:37 AM
    • Marked as answer by anahimself Friday, January 8, 2016 3:42 PM
    Friday, January 8, 2016 10:03 AM

All replies

  • Hi anahimself,

    Please start by verifing that the SQL-DBs are set to Recovery Model: Full. You can do this via SQL Management Studio.
    If the DBs are configured with Recovery Model: Simple, DPM will not be able to perform the backup of the logs.

    EDIT: Remeber to stop and re-add the SQL-DBs if you change the Recovery Model. Even thought you have auto-protection enabled, DPM will not know that the Recovery Model has changed.

    Kind Regards
    Markus


    • Edited by MarkusEliasson Friday, January 8, 2016 11:37 AM
    • Marked as answer by anahimself Friday, January 8, 2016 3:42 PM
    Friday, January 8, 2016 10:03 AM
  • This is absolutely correct.
    Friday, January 8, 2016 3:42 PM
  • For information:

    - I did change the recovery model and stopped the protection (the protection group was deleted because it was the only server in this group)

    - I did readd the server with all databases (automatic mode)

    Despite all that, DPM didnt see the changes in recovery model and still the 2 same databases are scheduled every 4h

    More informations on DPM agent log:

    0A50        1150        01/28      19:20:25.239           61            neapplicationnamespace.cpp(2256)      [00000000009B6BE0]                             NORMAL                InitializeSQLQueryHelper: SQL Query Helper is initialized to SQL Instance [REASQL01] from SQL Instance []

    0A50        1150        01/28      19:20:25.246           61            neapplicationnamespace.cpp(2445)      [00000000009B6BE0]                             NORMAL                IsIncrementalAllowed --> countSimpleMode 1, countReadOnly 0, countLogShipPrimary 0

    0A50        1150        01/28      19:20:25.250           61            neapplicationnamespace.cpp(2445)      [00000000009B6BE0]                             NORMAL                IsIncrementalAllowed --> countSimpleMode 0, countReadOnly 0, countLogShipPrimary 0

    0A50        1150        01/28      19:20:25.253           61            neapplicationnamespace.cpp(2445)      [00000000009B6BE0]                             NORMAL                IsIncrementalAllowed --> countSimpleMode 0, countReadOnly 0, countLogShipPrimary 0

    0A50        1150        01/28      19:20:25.255           61            neapplicationnamespace.cpp(2445)      [00000000009B6BE0]                             NORMAL                IsIncrementalAllowed --> countSimpleMode 0, countReadOnly 0, countLogShipPrimary 0

    0A50        1150        01/28      19:20:25.258           61            neapplicationnamespace.cpp(2445)      [00000000009B6BE0]                             NORMAL                IsIncrementalAllowed --> countSimpleMode 1, countReadOnly 0, countLogShipPrimary 0

    0A50        1150        01/28      19:20:25.260           61            neapplicationnamespace.cpp(2445)      [00000000009B6BE0]                             NORMAL                IsIncrementalAllowed --> countSimpleMode 0, countReadOnly 0, countLogShipPrimary 0

    0A50        1150        01/28      19:20:25.263           61            neapplicationnamespace.cpp(2445)      [00000000009B6BE0]                             NORMAL                IsIncrementalAllowed --> countSimpleMode 0, countReadOnly 0, countLogShipPrimary 0

    countSimpleMode is 0 for the 5 databases that doesnt work for sync

    No clue about what to do next..

    • Edited by anahimself Thursday, January 28, 2016 7:49 PM
    Thursday, January 28, 2016 4:30 PM