Trans Repl and Mirroring | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Trans Repl and Mirroring

I knew it is different, just similar…. Can anybody here explain the difference in an easily-understanding way.. Appreciate it. ——————
Bug explorer/finder/seeker/locator
one main diff: mirroroed DB is not available for queries. replicated db is available for queries/modification.
Check out BOL for other subtle differences. ***********************
Dinakar Nethi
SQL Server MVP
Read the following articles and thread… Database Mirroring in SQL Server 2005 SQL Server 2005 Books Online
Transactional Replication Overview…abase Mirroring&rnum=1&hl=en#8abf54a4532787b8 MohammedU.
Replication is different as compared to Database mirroring, as first can only be managed with columns and few tables but whereas the former is on database level which is a good option to manage warm-standby on high availability practices. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.