Configuration of logshipping

Prerequisites for log shipping

Steps for configuring LogShipping on Primary Server 

Step 1:  Connect to DB and select DB where you want to configure log shipping 

Step 2:  Right click on DB --- > Go to properties

Step 3 : Click on Transaction Log Shipping option.

Step 4:  

1. Enable Log shipping Configuration for primary database
2. Click on Backup Settings to configure Log Shipping for primary database.
3. Click on ADD to add Secondary database settings.

Step 5: Click on Backup Settings 

Schedule Backup Job

Step 6: Add Secondary database settings

a. Initialize Secondary Server tab.

b. Copy File tab

Schedule Copy Job.

c. Restore Transaction log tab

Schedule restore Job

Step 7 : Click on finish.  Log shipping Configured successfully. 

Step 8 :  

On Primary Server :-

In SQL Server Agent : 

LSbackup_DB_NAME job gets created , who takes the log backup of latest transaction log.

On Secondary Server :-

DBA database is in standby/Read-only mode.

In SQL Server Agent : 

Two jobs get created

• LSCopy_SecondaryServer_DBname  -- Copy latest Transaction to secondary server
• LSRestore_SecondaryServer_DBname -- Restore latest Transaction to secondary server

Run All jobs at below sequence:

• Backup job
• Copy Job
• Restore Job