Answered by:
Mirroring with log shipping?

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 VFriday, March 4, 2011 9:29 AM