Search This Blog

Thursday, July 11, 2013

Unable to Create Initial Replica for SQL 2012

 

Continue reading if you are facing the same scenario

Scenario:

a) Try to backup SQL 2012 using DPM 2012 or 2012 R2 (Preview)

b) DPM failed to create initial replica. An error message “Unable to configure protection” and total recovery point is 0.

DPMError1

Resolution:

a) Connect to the SQL Server 2012 instance through the Management Studio, then select and expand Security.

b) Expand Logins and right-click NT AUTHORITY\SYSTEM and select Properties. Click Server roles, select sysadmin and click OK

image

c) Remove the old protection group and re-create. Your backup should be working right now,