Difference Between Replication and Database Mirroring
Difference Between Replication and Database Mirroring? NEED SOME POINTS
This site runs off of you casting votes. If any of the answers below was helpful, indicate this by clicking on the thumbs up next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer.
Best Answer
Database mirroring is primarily a high availability function while replication is meant for providing mechanisms to maintain copies of databases for use in reporting and other things. The Books Online are pretty clear on exact functionality of [Mirroring][1] and [Replication][2]. [1]:
http://msdn.microsoft.com/en-us/library/ms189852.aspx [2]:
http://msdn.microsoft.com/en-us/library/ms151198.aspx
Think of mirroring as if it were Logshipping on steroids with some very good uses. Those uses for mirroring got amped a bit more with the changes introduced in SQL 2012.
