• Thanks Lempster for your kind reply.

    I'm using Transactional Replication.

    Now please let me know, is there any option to create failover replication? if yes, how to do that?