Interview Questions
1. What is Log Shipping?
Log shipping is the process of automating the backup of database and transaction log files on a production SQL server, and then
restoring them onto a standby server. But this is not all. The key feature of log shipping is that it will automatically backup
transaction logs throughout the day (for whatever interval you specify) and automatically restore them on the standby server.
This in effect keeps the two SQL Servers Databases in “synch”.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment