SQL SERVER LOG SHIPPING 2017

To install and configuration of Log shipping of SQL Server Database we need to follow below steps.

There are some prerequisites for Log shipping.

1. Same version of SQL Server database should be installed on both servers.
2. Static IP should be configured on both servers.
3. Shared folder should be configured on both servers with read and wright permission.
4. Connectivity of both servers should be working.
5. SQL Server services should be run on same account
6. SQL Agent service should be run on same account

Steps to configure the Log shipping:

Login on server and then open SQL server management studio, right click on database select Task and click on Ship Transaction Logs.

In this steps select Enable this as a primary database in a log shipping configuration and click on Backup Settings

In this steps type the network path of folder that we created (shared folder) of primary server as shown below image, and in second section type the local path of shared folder and click on Schedule button to configure the schedule for backup of database.

In this step we configure the schedule for database backup timings, by default it is configured for 15 minutes on daily basis. We can change it as per our requirement. In our case we took default value.

Now click on ok button.

Now click on Add button to connect to secondary server.

A pop window will open, select the secondary node, enter the User name and password of database and click on connect button.

Once connection succeeded. Below screen will appear, select the first options and then click on Restore options, type the folder path for the database and logs files (if any) as shown below image and click on ok.

Now select Copy Files (second option) and type the Network path of Secondary server (shared folder path of secondary server), Database backup will be copied on this folder, and then select restore Transaction Log and then click on Ok

In Restore Transaction Log Select No Recovery Mode and click on Ok button.

When we click on ok button in above step configuration of Log Shipping service start to configure the Log Shipping.  Once configuration parts completed it shows success message as shown below, now click on close button.

Now go to secondary server and login SQL Server Management Studio, Expand the database and see database Log Shipping has been completed and database is in restoring mode.