2
Reply

What is log shipping?

Ankur Jain

Ankur Jain

Aug 18, 2014
925
0

    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.

    Ankur Jain
    August 18, 2014
    1

    Log Shipping was introduced in SQL Server 2000 , The main advantage of this is maintain multiple servers as standby server,robust ,we can decide the time interval.Internally when Log Shipping is configured,there are 4 jobs create between Primary Server and Secondary Server, they are Backup Job,Copy Job,Restore Job Alert Job.

    SAM ROCK
    October 02, 2014
    0