none
DPM 2007 and SQL DBAs / Windows Admins responsibility delineation RRS feed

  • Question

  • We are currently using DPM 2007 to manage the backups of our Windows infrastructure including SQL 2005 and SQL 2008. With the advent of the DBAs now taking full responsibilities for the management of the SQL servers we are now trying to find the best possible process for the backup and restore processes of SQL databases.

     

    Obviously, the Windows administrators would prefer not to give full access to the DPM system to the SQL DBAs whilst we also need the SQL DBAs to be able to use the DPM infrastructure (and not built-in SQL tools) to manage all backups and restores in order to maintain data integrity of the DPM backups.

     

     

    1. What would be the least possible role based privileges on DPM to satisfy this? or

    2. Would it be better to de-couple the backups of SQL so that backups and restores are done within SQL Maintenance plans by the SQL DBAs and the resultant flat backup files are backed up with DPM? or

    3. Other suggestions?

    • Moved by Praveen D [MSFT] Wednesday, November 10, 2010 9:37 AM Moving to DPM SQL Protection (From:Data Protection Manager)
    Tuesday, November 2, 2010 4:19 AM

All replies

  • Hi Gavo!

    If you want to let the DBA manage their own restore you should consider upgrading to DPM2010. In verison 2010 of DPM you got the Self-Service Recovery Configuration Tool or SSRCT. With this tool you will be able to let the DBA's preform a restore that you have written a policy for. You are in control of witch databases your DBA's can restore and where the restored information is stored.

    Look at this link: http://technet.microsoft.com/en-us/library/ff399189.aspx

    If you got further questions please get back with those.

     

    BR

    Robert Hedblom



    Check out my DPM blog @ http://robertanddpm.blogspot.com

    Tuesday, November 2, 2010 7:48 AM
    Moderator
  • Thank you Robert

     

    I appreciate you taking the time in responding to my query.

     

    The issues are that:

    1. We are still on DPM 2007 and the upgrade project to 2010 will occur next financial year at the earliest.

    2. From a quick read of the features of DPM 2010, the role based recovery doesn't go far enough to meet our needs. The SQL DBAs should have full control over their database backup and restore processes. The role based recovery will only allow restores but the SQL DBAs also need the capability to do adhoc backups or to maintain the backup schedules.

    3. Do you know of any other options or best practices with DPM2007 and even DBAs in DPM2010?

     

    Thank you again for the information you have provided 


    Gavin
    Tuesday, November 2, 2010 9:43 AM
  • Hi Gavin!

    There has been a thread earlier regardig a similar question, I can't find that thread. A nice feature would be if different users in your domain would be listed with different protection groups and administrative rights depending on membership of different AD security groups.

    There isn't any way that I'm aware of that lets you choose what your SQL DBA's would or wouldn't see. The closest you get is by using the SSRCT tool provided in DPM 2010.

    Perhaps some nice gentlemen from the product team knows a tick or two?

     

    BR

    Robert Hedblom



    Check out my DPM blog @ http://robertanddpm.blogspot.com

    Tuesday, November 2, 2010 10:25 AM
    Moderator
  • As Robert has mentioned there is no such facility for SQL DBAs in DPM 2007. In DPM 2010, we have restore functionality using Self Service recovery tool. For more details please take a look at: http://technet.microsoft.com/en-us/library/ff399008.aspx

     


    Thanks, Hitesh “This posting is provided "AS IS" with no warranties, and confers no rights.”
    • Proposed as answer by Hitesh S Sharma Thursday, February 10, 2011 9:30 AM
    Thursday, February 10, 2011 9:29 AM
  • Hi Gavo 00.

     

    Does the answer given by Robert/Hitesh addressed your issue?

     

    <Quote>

    As Robert has mentioned there is no such facility for SQL DBAs in DPM 2007. In DPM 2010, we have restore functionality using Self Service recovery tool. For more details please take a look at:http://technet.microsoft.com/en-us/library/ff399008.aspx

    <End Quote>


    Thanks, Wilson Souza - MSFT This posting is provided "AS IS" with no warranties, and confers no rights
    Friday, May 20, 2011 9:54 PM
    Moderator