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?
asked Oct 30, 2009 at 12:18 AM in Default
Steve Jones - Editor ♦♦
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.
answered Oct 30, 2009 at 05:55 AM
Log Shipping does not provide failover or failback capabilities.
Mirroring will allow failover if a Witness server is included in the configuration.
Microsoft and PolyServe clustering both provide automatic failover.
answered Oct 30, 2009 at 11:36 AM