2
Reply

What is log shipping?

Ankur Jain

Ankur Jain

10y
939
0
Reply

    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.

    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.