interviews.dotnetthread.com

↑ Grab this Headline Animator

Wednesday, July 9, 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.

Submit this story to DotNetKicks

No comments:

Post a Comment

Post your comments/questions/feedback for this Article.

 

Latest Articles