locked
Mirroring with log shipping? RRS feed

  • Question

  • Is it possible to maintain no.of.mirror databases in Mirroring.

    I faced this question in  one of interview, I answered not possible in mirroring its possible with log shipping.

    The interviewer told me that its possible Mirroring with log shipping concept( mirror databases can be maintain in multiple servers )

    Is there any concept like that please clarify.

    Sunday, February 27, 2011 5:50 AM

Answers

  • With database mirroring alone you can only mirror to one server not multiple. However you can maintain more than one target/destination server by mirroring to one server and log shipping to others. So a log shipping principle can also be a mirroring principle. So it really depends on how the interviewer worded the question. Have a look at the following for more details...

    http://msdn.microsoft.com/en-us/library/ms187016.aspx

     

    Thanks


    /Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005), MCAD, OCA 11g) Please click the Mark as Answer button if a post solves your problem
    • Proposed as answer by LekssEditor Monday, February 28, 2011 11:26 PM
    • Marked as answer by WeiLin Qiao Wednesday, March 9, 2011 9:49 AM
    Sunday, February 27, 2011 10:16 AM

All replies

  • With database mirroring alone you can only mirror to one server not multiple. However you can maintain more than one target/destination server by mirroring to one server and log shipping to others. So a log shipping principle can also be a mirroring principle. So it really depends on how the interviewer worded the question. Have a look at the following for more details...

    http://msdn.microsoft.com/en-us/library/ms187016.aspx

     

    Thanks


    /Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005), MCAD, OCA 11g) Please click the Mark as Answer button if a post solves your problem
    • Proposed as answer by LekssEditor Monday, February 28, 2011 11:26 PM
    • Marked as answer by WeiLin Qiao Wednesday, March 9, 2011 9:49 AM
    Sunday, February 27, 2011 10:16 AM
  • this thread will give you more

    http://social.msdn.microsoft.com/forums/en-US/sqldatabasemirroring/thread/ee05954e-0934-4305-8936-b9226e231d06/

     

    Cheers

    Monday, February 28, 2011 9:22 AM
  • Just to give further information in 2011 "Denali" this is being added up .

    Database can be mirrored on multiple servers and even the database can be put in readonly mode . Refer the following blog
    http://blogs.msdn.com/b/sqlalwayson/archive/2010/12/08/alwayson-availability-group-and-database-mirroring.aspx

    -----------------
    Thanks,Suhas V

    Friday, March 4, 2011 9:29 AM