Ankur Jain
What is log shipping?
By Ankur Jain in SQL Server on Aug 18 2014
  • Ankur Jain
    Aug, 2014 18

    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.

    • 1
  • SAM ROCK
    Oct, 2014 2

    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.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS