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
Log Shipping Failover and failback
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.
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.
