• About the identity column, I just truncated the table on pricipal and inserted few rows and failed over to the other server. When i started inserting the rows again the value jumped into 1000s. Everytime i failover to the other it's incrementing to 1000's.

    fidfname

    6pears

    7pears

    1002pears---failed over

    1003pears

    1010pears

    2002pears--failed over

    2003pears

    2004pears