fbpx

Category Archives for "SQL"

DPM 2012–Event ID 3184 Owner DPM Server

Recently I had an incident on the DPM 2012.  It’s the ActiveOwner issue. I’m going to share with you how I done it. The ActiveOwner files are located in “c:program filesMicrosoft Data Protection Managedpmactiveowner” on the server hosting the databases (SQL server being backed up). In my case it is one of the SQL server […]

Continue reading

DPM 2012–Event ID 3184 Owner DPM Server

Recently I had an incident on the DPM 2012.  It’s the ActiveOwner issue. I’m going to share with you how I done it. The ActiveOwner files are located in “c:program filesMicrosoft Data Protection Managedpmactiveowner” on the server hosting the databases (SQL server being backed up). In my case it is one of the SQL server […]

Continue reading

SCDPM – Protecting SQL 2012 & above.

To protect SQL Server 2012 or SQL Server 2014, the following must be done. Login to SQL Server Management Studio Add the system account NTAuthoritySystem to the Sysadmin group on SQL Server DPM cannot protect databases that are stored on remote SMB stores Availability group replicas are configured as read-only When you perform an alternate […]

Continue reading

SCDPM – Protecting SQL 2012 & above.

To protect SQL Server 2012 or SQL Server 2014, the following must be done. Login to SQL Server Management Studio Add the system account NTAuthoritySystem to the Sysadmin group on SQL Server DPM cannot protect databases that are stored on remote SMB stores Availability group replicas are configured as read-only When you perform an alternate […]

Continue reading

DPM Reporting – An error has occurred during report processing

I hit an issue on launching the DPM reporting.  The DPM is functioning well except the reporting.  It’s the issue of the SQL Reporting settings. It stated as : An error has occurred during report processing. (rsProcessingAborted).Query execution failed for dataset ‘DataSet2’. (rsErrorExecutingCommand)Invalid object name ‘vw_DPM_Replica’. Steps taken to resolve : Launch the Reporting Services […]

Continue reading