Category Archives: Replication

SQL Server High Availability and Database Recovery Model Relationship

There are four types of high availability options available in Microsoft SQL server. All the options are different from each other. For example, Log shipping, Mirroring and Always On works on database level while Replication works on database objects level. … Continue reading

Rate this:

Posted in T-SQL, Sql Server, Replication, Database Administration, Always on | Leave a comment

SQL SERVER ERROR- Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF

SQL SERVER ERROR- Cannot insert explicit value for identity column in table ‘tablename’ when IDENTITY_INSERT is set to OFF Yesterday I got this error while monitoring the replication status of a server. The actual error is in snapshot as below: … Continue reading

Rate this:

Posted in Database Administration, Replication, Uncategorized | Leave a comment