top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

What is log shipping?

+4 votes
44 views
What is log shipping?
posted Nov 28, 2014 by Manikandan J

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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.

answer Nov 28, 2014 by Jdk
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...