Log Shipping in SQL Server 2008R2 Step by Step

Introudaction

SQL Server Log Shipping Allow to Transfare Data Form one Database  (Primary) to a lot of Database (Secondry) So in Log Shipping we have three Srrvers (Primary , Secondry (optinal) monitor ) . the Secondry Server can be More than one Database

Log shipping involves copying a database backup and subsequent transaction log backups from the primary (source) server and restoring the database and transaction log backups on one or more secondary (Stand By / Destination) servers

#######################################################################################

1-       Create Folder in Primary Server (LogShipping_Primary) aslo in Secondry Server Create Folder Name (LogShipping_Secondry) this two Folders must be sharing .

2-      Take Full and transaction log backup from the database (Log Shipping) in Primary Server.

3-      Restore this Database on Secondry Server with Stand By option.

4-      On primary Server Write Click >>> properties  >>> Log Shipping n >>>> Enable log Shipping.

5-      Configure the backup Setting for the Transaction Log backups

• Network backup path Folder : the Folder name LogShipping_Primary in Primary Server put the network path for this Folder \\Servername\Foldername
• Local path : the local path for the folder in primary Server like C:\users\DBA\Desctop\LogShipping_Primary

6-      Configure Sechudel job to the backup database

7-      Add Secondry Server

8-      Connect to Select your Secondry Server

9-      Initialize Secondry Database

• First option         : if you want to take Full backup the restore it to the Secondry Server
• Seconde Option : If you won’t to Restore the backup from the primary Server to the Secondry Server
• Theird option      : if you Take the backup and already restore it to the secondry server   (like my example)

10-      Copy files : in this tabe you will put the path of the Folder in Secondry Server put you will put it like this \\Servername\Foldername

10-      Configure the Sehedule to take the backup files copy from the primary server to the secondry server

11-      Restore transaction log : we will select Standby option and Disconnect all user in restore operation

12-      Configure the Sehedule to restore the backup taken from the primary Server

13-      Then ok

14-      Optinal (Check on monitor Server instance to monitor the backup Status  and the job Status  for the Jobs in primary Server and Secondry Server

14-      last Step in Log Shiping Configuration

14-      After you finish from the Log Shipping go to the Primary Server to Check the new jobs

15-      Return to the Secondry Server to Check the new Jobs