Also check out Log Shipping and Failover Clustering in BOL.

>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