Thursday, June 12, 2008
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. Enterprise Editions only supports log shipping. In log shipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db can be used this as the Disaster Recovery plan. The key feature of log shipping is that is will automatically backup transaction logs throughout the day and automatically restore them on the standby server at defined interval.
Labels:
Interview Questions
Reactions: |
Subscribe to:
Post Comments (Atom)
2 comments:
guess you are wrong dude... Log shipping is supported in Developer and Standard Editions as well...
Hi Suman,
Log Shipping is Supported in Developer Edition but not in Standard Edition.
Post a Comment