Check constraints warnings observed in the SQL Server log after restoring a database backup taken from SQL 2008\2008R2 instance onto SQL Server 2012\2014 instance.
Last Published: January 11, 2016ArcSDE/Enterprise Geodatabase
Bug ID Number
November 4, 2015
June 11, 2020
After review by the development team, it has been determined that this issue is related to a known limitation with the software that lies outside of Esri's control. The issue's Additional Information section may contain further explanation.
This is basically MS issue.
Manually change all constraints generated in the SQL Server log back to CHECK from NOCHECK.