Following are the step by step configuration guide of log shipping.
Configuring Log Shipping:
Step1:-
For configuring log shipping first connect to instance of sql server -> expand the database->right click on database which you want to configure for log shipping->select the task option or database property ->you got below window:-
Step2:-
Select ship transaction log ->then you got below window->first click checkbox to enable primary database in log shipping configuration
Step3:-
Select the backup setting tab->first create share folder on primary server which have read/write permission->copy share folder path and paste this folder as shown below.
you can also schedule the backup time or other setting by clicking on edit schedule tab then
click on ok tab
Step4:-
Click add tab to add secondary instance(server)
Step5:-
Click on connect tab
->connect secondary instance through putting login and password
Step6:-
Select appropriate option initialize secondary database tab then go to copy file tab to configure copy files configuration
In initialized database there are three option as above shown:
first option :-
You generate full backup and restore into secondary database (create secondary database if secondary database does not exist)
You generate full backup and restore into secondary database (create secondary database if secondary database does not exist)
Second option :-
Restore an existing backup of primarydatabase into secodary database (create secondary database if does not exist)
Third option :-
Database intialized-
Step7:-
Click on copy file tab
->Create destination folder on secondary instance which have read permission->copy destination folder path and paste on space as shown in below screen.
You can also shedule the copy time or other setting by clicking on schedule tab
Step8:-
Click on restore transaction log tab to manage restore transaction setting as shown below screen:
You can also shedule the restore transaction log time or other setting by clicking on shedule tab
There are two options:
1.No recovery mode is denotes database leaves in restoring modeand database is unavailable.
2.Standby mode is denotes database leaves in read only or standby modeand uncommited transaction saves in tuf file.
Step9:-
Then you click ok you will get below screeen
All setting got confirmed and your secondary databse (secondary server) is also added as shown in above figure->click on ok tab->your job will start as shown in below screen->after that your job will sheduled->inspection are done through sql server agent confirmation success.
Advantages of Log Shipping:
1. Log shipping can combined with other disater recovery option such as database mirroring and database replication.
2. Log shipping supports full and bulk logged recovery model.
3. In log shipping one primary server and number of secondary server.
4.There is no limitation of database can configured on primary server for log shipping.
5.Database recovery state on secondary server are norecovery and standby\readonly mode.In read only mode database can read on secondary server.
Disadvantages of Log Shipping:
1. It supports only manual failover does not support automatic failover.
2. Log shipping is totally dependent on sql server agent and it should be always on with resepct to shipping the logs from primary to secondary server.
3. There is possiblity of data loss in log shipping than database mirroring.
