Hi, You have to perform failover manually, refer Log Shpping,failover in BOL for more information and steps If you have replication setup on primary server and if primary server fails, replication won't continue refer http://msdn2.microsoft.com/en-us/library/ms151224.aspx and it is suggested to use...