none
Move DPM_SQL_PROTECT after moving Database Files - DPM2010 RRS feed

  • Question

  • After moving the database files in SQL (using detach/reattach) is there a way of getting the DPM_SQL_PROTECT to move to the new file location (without unprotecting and re-protecting the datasource).

    For example:

    Original:

    f:\old_DB_location\db.mdf
    f:\old_DB_location\db.ldf
    f:\old_DB_location\DPM_SQL_PROTECT\all the backup stuff

    After detach/reattach:

    f:\new_DB_location\db.mdf
    f:\new_DB_location\db.ldf
    f:\old_DB_location\DPM_SQL_PROTECT\all the backup stuff

    Note: if you delete the DPM_SQL_PROTECT folder (when DPM is not running) then on the next synchronisation it gets recreated.

    What we want:

    f:\new_DB_location\db.mdf
    f:\new_DB_location\db.ldf
    f:\new_DB_location\DPM_SQL_PROTECT\all the backup stuff

    Thursday, April 4, 2013 10:12 AM

Answers

  • Hi Tobie,

    Did you tried to "modify" your PG (Update Group) ?

    Stephane.


    Please remember to click “Mark as Answer” on the post that helps you. This posting is provided "AS IS" with no warranties. knowledge is valid only if it is shared by All.

    My DPM blog Yet Another DPM Blog



    Thursday, April 4, 2013 12:54 PM

All replies

  • Hi Tobie,

    Did you tried to "modify" your PG (Update Group) ?

    Stephane.


    Please remember to click “Mark as Answer” on the post that helps you. This posting is provided "AS IS" with no warranties. knowledge is valid only if it is shared by All.

    My DPM blog Yet Another DPM Blog



    Thursday, April 4, 2013 12:54 PM
  • Hi Stephane,

    That was part one - then I needed to kick off a manual consistency check. Thanks for the pointer to the Update Group.

    Regards
    Tobie

    Thursday, April 4, 2013 1:23 PM