Summary
Verification failure of a Microsoft SQL Server 2012 backup can be corrected by adjusting permissions on the SQL Server verification node.
Symptoms
SQL Server 2012 verification job fails with errors such as the following:
3312: Failed to attach the database qk.1335244618@EWR-SQL2K12V, rc[127]
.
3312: Failed to verify the sql db(qk) rc(-21)
.
Resolution
On the SQL Server 2012 verification node, grant the following server roles to NT AUTHORITY\SYSTEM:
- SysAdmin
- ServerAdmin
- SetupAdmin
- SecurityAdmin
- ProcessAdmin
- DBCreator
- DiskAdmin
- BulkAdmin