If I have log shipping running from my Sales server to the SalesDR server and I failover, will log shipping automcatically start from SalesDr to Sales when Sales is available? Will it fail back automatically?
Answer by sp_lock ·
Log shipping is a manual failover. Data loss is also possible depending on the freqency the logs are shipped to the failover server.
Failback is also no possible automatically.
A couple of auto failovers include Mirroring (if the application supports it - .NET apps have connection string setting) and Clustering.