locked
Reg Database Mirroring and Log Shipping Working Together RRS feed

  • Question

  • We are going to create Database Mirroring and Log Shipping Working Together..Is there any drawback on this?
    Sunday, September 9, 2012 9:49 PM

Answers

All replies

  • Shouldn't be a problem - but I have to ask why?  Are you able to upgrade to SQL Server 2012 so you can have multiple replica databases?

    Jeff Williams

    Sunday, September 9, 2012 10:05 PM
  • Hi,

    As Jeff said yes you can mirror and log ship at the same time and it is fully supported and I have never had any issues with this scenario.

    http://msdn.microsoft.com/en-us/library/ms187016%28v=sql.105%29.aspx


    Sean Massey | Consultant, iUNITE

    Feel free to contact me through My Blog, Twitter or Hire Me.
    Please click the Mark as Answer or Vote As Helpful button if a post solves your problem or is helpful!

    Monday, September 10, 2012 1:20 AM
  • Mirroring and Log shipping will not create a problem, but think of the SQL Server performance, if all the Server Resources are consumed for High Availability, what about the application performance ?

    Ramesh Babu Vavilla MCTS,MSBI

    Monday, September 10, 2012 5:35 AM