DB Mirroring and Log Shipping

• WWDMark

  Hall of Fame

  Points: 3157

  More actions

  January 9, 2013 at 6:11 am

  #287270

  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: http://markallen.co.uk/
  Business Website: https://www.weekendwebdesign.co.uk

• Rama Chandra Gowtham. Peddada

  SSC Veteran

  Points: 271

  More actions

  January 9, 2013 at 6:43 am

  #1575218

  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