Tnx Craig,

Does this mean that in case my main SQL server failed I can use the other Sql Server as their main server? I just need to change the IP address and the hostname of the replication SQL like the main SQL server?.

can u walk me thru this.

tnx