DB Mirroring and Log Shipping

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » DB Mirroring and Log Shipping

DB Mirroring and Log Shipping

Rate Topic

Display Mode

Topic Options

Author

Message

WWDMark

Posted Wednesday, January 09, 2013 6:11 AM

SSC-Addicted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:02 AM
Points: 446, Visits: 348

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
Website: www.weekendwebdesign.co.uk

Post #1404720

Rama Chandra Gowtham. Peddada

Posted Wednesday, January 09, 2013 6:43 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, January 12, 2013 10:49 AM
Points: 14, Visits: 129

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 »

Permissions