This article explains the step by step deployment process of the SQL Server Log shipping. It is the database-level disaster recovery solution that is easy to set up and maintain.
The log shipping involves three steps:
- Generate the log backup on the primary database.
- Copy the backup to the network location or the specific directory on the secondary server.
- Restore the log backup on the secondary server.
The log shipping technology performs the steps described above by using SQL Server agent jobs. During the configuration process, the log shipping wizard creates those jobs on primary and secondary servers.
Read More