Step by step Log Shipping configuration in SQL Server? OR Step by step Log Shipping configuration using SSMS window wizard and using SQL Script?

Important note and configuration details-

·         Primary Server : INHYIZLP10744

·         Secondary Server : INHYIZLP10744\Instance1

·         Database Name: Logshipping_Test_DB

·         All MSSQLServer service and SQL Agent service running with same account on both server.

·         Database in Full or bulk logged recovery model only

·         Collection should be same

·         Connect both server with same SQL Server user account (User or service account should and sysadmin permission on both server )

Please click on below link to  download word file-

Step by step Log Shipping configuration in SQL Server


This doc have below both type of configuation steps-

1. Using User interface (UI)
2 Using SQL server script

Please let me know if you know any other method to do the same - Jainendra Verma