Setting Up Mirroring and Log Shipping Together.

Setting Up Mirroring and Log Shipping Together.

Prerequisite (Sql Server 2005)
•Server A ( Principal)
•Server B (Mirror)
•Server C ( Secondary Standby) for Logshipping
•Share Folder on Network, Accessible by all three Servers (A, B & C).

1.Restore backups of the principal/primary database with NORECOVERY onto another server instance to be later used as database mirroring mirror database for the principal/primary database.

2.Set up database mirroring.
E.g. Configuring Mirroring on Principal Server.
Server A: Mir (Principal , Synchronized)





Server B: Mir (Mirror , Synchronized/Restoring)




3.Restore backups of the principal/primary database to other Destination server instances to be used as log shipping.

E.g Restore Backup of Mir database from Server A to Server C with NoRecovery.

4.Create a Network share Folder to take Tlog backup for both Server A (Principal Databases) and Server B(Mirrored Database)
E.g. \\192.168.1.15\Backup -- This Share folder will be used\accessible by Server A, Server B and Server C.

5.Create a Network Share Folder for Copying Tlog from source to destination.
E.g. \\192.168.1.15\Dest_Backup -- Destination Share Folder from where restore of Log will be done to Server C.

6.Set up log shipping on the principal database from Server A to Server C according to Schedule backup, restore and latency required.( Use Sql 2005 Management Studio) check Restore Tab option for Standby\ No recovery.
Server C: Mir (Standby/Read only)

7.Disable Following job
1. Disable Logshipping Backup job on server A.
2. Disable Logshipping Copy Job on server C.
3. Disable Logshipping Restore Job on server C.

8.Set up log shipping on the mirror as the inactive primary database. Follow below steps.
a.Failover Database Mirroring to Server B.
b.Use same shared folder for Backup and Destination e.g. as used above
\\192.168.1.15\Backup
\\192.168.1.15\Dest_Backup
c.Set up log shipping similar to done in step 6 from Server B to Server C.

9.Failover Mirroring to Server A.

10.Enable all job disable in Step 7.
1.Enable Logshipping Backup job on server A.
2.Enable Logshipping Copy Job on server C.
3.Enable Logshipping Restore Job on server C.
Check logshipping Job are running sucessfully as schedule.