Answer
Log Shipping copies log backups to a secondary server for restore. Simple, reliable, but no automatic failover.
Quick Answer
Log shipping automatically copies and restores transaction log backups from a primary to one or more secondary servers. Simple and cheap — just a SQL Agent job. Secondaries are in restoring state (read-only via STANDBY). No automatic failover; manual intervention required. Predecessor to AlwaysOn AG.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ