none
What are the permission required at Client SQL server side to configure backup in DPM 2019 RRS feed

  • 질문

  • I am planning to start SQL DB backup by DPM. I am logging in DPM server with my domain Admin account ARIF which has DPM Admin rights and other file servers backup is running ok.

    1. What is permission required at client SQL DB to start backup?

    2. Do  I need permission at each SQL DB?

    3. Suppose I take online backup of SQL DB 2012 and I restore it at SQL DB 2016, will this create problem?

    4. Do I need any special permission at there server where I am planning to restore it. FYI, have already installed MS SQL 2016 setup and created a default instance.


    Arif

    2020년 5월 14일 목요일 오전 6:24

답변

  • Hi,

    1. What is permission required at client SQL DB to start backup?

    DPM doesn't need permissios to the SQL Sever itself to back up the databases, it runs under the LocalSystem (NT AUTHORITY\SYSTEM) account which is a high privilege account within Windows.

    2. Do  I need permission at each SQL DB?

    No, you only need the DPM agent installed on each SQL database server.

    3. Suppose I take online backup of SQL DB 2012 and I restore it at SQL DB 2016, will this create problem?

    This should work you can always go forward, but you can't go backwards, at least not with backup and restore functions within the SQL Server Management Studio.

    Note that you can't recover a system database to a different instance of SQL Server.

    4. Do I need any special permission at there server where I am planning to restore it. FYI, have already installed MS SQL 2016 setup and created a default instance.

    No.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    • 답변으로 표시됨 azahri miya 2020년 5월 15일 금요일 오전 8:43
    2020년 5월 14일 목요일 오전 7:35
  • 1. How many storage pool can bee added in DPM 2019 to store the backup sets?

    As far as I know, no limit

    2. What is DPM service name at client machine after pushing agent?

    DPMRA


    Blog: https://thesystemcenterblog.com LinkedIn:

    • 답변으로 표시됨 azahri miya 2020년 5월 15일 금요일 오전 8:43
    2020년 5월 15일 금요일 오전 7:09

모든 응답

  • Hi,

    1. What is permission required at client SQL DB to start backup?

    DPM doesn't need permissios to the SQL Sever itself to back up the databases, it runs under the LocalSystem (NT AUTHORITY\SYSTEM) account which is a high privilege account within Windows.

    2. Do  I need permission at each SQL DB?

    No, you only need the DPM agent installed on each SQL database server.

    3. Suppose I take online backup of SQL DB 2012 and I restore it at SQL DB 2016, will this create problem?

    This should work you can always go forward, but you can't go backwards, at least not with backup and restore functions within the SQL Server Management Studio.

    Note that you can't recover a system database to a different instance of SQL Server.

    4. Do I need any special permission at there server where I am planning to restore it. FYI, have already installed MS SQL 2016 setup and created a default instance.

    No.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    • 답변으로 표시됨 azahri miya 2020년 5월 15일 금요일 오전 8:43
    2020년 5월 14일 목요일 오전 7:35
  • Thank you for reply. can you please few more question :)

    1. How many storage pool can bee added in DPM 2019 to store the backup sets?

    2. What is DPM service name at client machine after pushing agent?


    Arif

    2020년 5월 15일 금요일 오전 7:01
  • 1. How many storage pool can bee added in DPM 2019 to store the backup sets?

    As far as I know, no limit

    2. What is DPM service name at client machine after pushing agent?

    DPMRA


    Blog: https://thesystemcenterblog.com LinkedIn:

    • 답변으로 표시됨 azahri miya 2020년 5월 15일 금요일 오전 8:43
    2020년 5월 15일 금요일 오전 7:09
  • I see that is not running but still all backups are successful . This service is running at any server but all backup are running successful.

    


    Arif

    2020년 5월 15일 금요일 오전 7:19
  • It is set to "Manual" start because DPM will trigger it to start once the backup/recovery jobs are scheduled.

    Blog: https://thesystemcenterblog.com LinkedIn:

    2020년 5월 15일 금요일 오전 7:23
  • I have configured the protection group and backups are running successful.

    You mean when a recovery point is about to run, DPM Server automatically "START" DPMRA service and when backup is completed, it puts DPMRA in "STOP"??


    Arif

    2020년 5월 15일 금요일 오전 7:28
  • 2020년 5월 15일 금요일 오전 7:29