none
SQL 2014 backup fails RRS feed

  • Question

  • Hello,

    Initially backup of DBs failed with error : The DPM job failed for SQL Server 2014 database DBname on SQL Server (server name) because the protection agent did not have sysadmin privileges on the SQL Server instance. (ID 33424 Details: )

    With recommended action : Add 'NT Service\DPMRA' to the sysadmin role on the SQL Server instance.

    I added account 'NT Service\DPMRA' with sysadmin in SQL and initiated backup, it failed with below error

    "Failure occurred while adding one or more of the volumes involved in backup operation to snapshot set. Please check the event log on SQL Server to troubleshoot the issue. (ID 30290 Details: Internal error code: 0x809909E2)"

    Unfortunately there are no logs getting captured in eventvwr in SQL server.

    Please help.

    DPM Version : DPM 2016, Build : 5.0.322.0

    SQL : 2014 SP2

    Pramodh

    Monday, June 5, 2017 2:40 PM

All replies