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
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx SQL Server 2005 Books Online
Transactional Replication Overview
http://msdn2.microsoft.com/en-us/library/ms151176.aspx http://groups.google.com/group/micr…abase Mirroring&rnum=1&hl=en#8abf54a4532787b8 MohammedU.
Moderator
SQL-Server-Performance.com
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
http://www.SQL-Server-Performance.Com
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.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |