none
DPM 2007 must backup SqlServer database to the same folder?? RRS feed

  • Question

  • We have just started protecting a SqlServer 2008 instance with Data Protection Manager 2007 SP1 and have noticed that about every three days an express backup (run daily) causes the SqlServer to hang.  My first thought is that I need to make sure the backup is occurring on a different volume than the database. Ok, but there appears to be absolutely no way to make the DPM Agent backup the database anywhere but in the same directory as the database!  I've got to figure this out because at some point the size of the database + the backup will be larger than the partition which would be bad.

    So here's the first question: How do I configure the DPM agent to backup the database to some volume other than the one the database is on?

    And, of course, the next question is: If the answer to the first question is, You Can't or it doesn't help with the SqlServer hanging issue on express fulls, what else can I do?

    -larry

    Wednesday, September 30, 2009 1:02 PM

All replies

  • Hi,

    This post appears to be related to System Center Data Protection Manager 2007. We recommend to refer to SCDPM newsgroup for more details:
    http://technet.microsoft.com/en-us/dpm/bb737891.aspx

    If there are any more questions, please let me know.
    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    Friday, October 2, 2009 6:31 AM
    Moderator
  • The light is better here ;-) 

    I have it posted over there, but there doesn't seem to be enough traffic.  A lot of questions go unanswered.

    -larry

    Friday, October 2, 2009 1:41 PM
  • Maybe this can help

    http://download.microsoft.com/download/6/8/3/683ba565-1d7d-4ce7-b78b-9f63e2bc41bc/DPM_whitepaper_Protecting_SQL_Server_with_DPM.doc


    What I understood is :

    1- There is a storage pool which is supposed to be on network and DPM will use it to transfer backups of databases to.

    2- you define a protection group to choose what you want to protect(SQl , exchange..etc).

    3- you add you SQL instances and databases.

    4- Choose Protection method (disk, tape or both). I think this may have a significance.

    HTH




    Please mark as answer if you think this answers your questions
    Monday, October 12, 2009 6:01 PM
  • one more , maybe you can watch this webcast

    http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?culture=en-US&EventID=1032384076

    THX
    Please mark as answer if you think this answers your questions
    Monday, October 12, 2009 6:02 PM