• Ok got it. in case this is sync (High availability) the there is no data loss and we can just issue ALTER DATABASE SET PARTNER FAILOVER.

    But there is ofcourse dataloss in async mode then we have to inform sql server about data loss.

    But one question... What about HIGH SAFETY (WITHOUT WITNESS). This is also sync. So according to me we can use ALTER DATABASE SET PARTNER FAILOVER. M I Correct?

    -Lucky