Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DB Mirroring and Log Shipping Expand / Collapse
Author
Message
Posted Wednesday, January 09, 2013 6:11 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:17 AM
Points: 636, Visits: 508
Hi all,
I'm using SQL Server 2008 R2 and was wondering if it's possible to set up DB mirroring on a principal database and set up log shipping with a load delay of for example 2 hours on the same primary database as part of a high availability/DR plan?

Many thanks,
M



MCITP
MCTS - E-Business Card
Twitter: WWDMark

Try not! Do or do not, there is no try

email: info@weekendwebdesign.co.uk
Personal Website: www.markallen-online.co.uk
Business Website: www.weekendwebdesign.co.uk
Post #1404720
Posted Wednesday, January 09, 2013 6:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 04, 2013 8:00 AM
Points: 15, Visits: 130
Hi,

We can set up Mirroring and log shipping on the same database. Below is the link that explains how it works.

http://msdn.microsoft.com/en-us/library/ms187016(v=sql.105).aspx
Post #1404747
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse