SQL Server Performance

Trans Repl and Mirroring

Discussion in 'SQL Server 2005 Database Mirroring' started by xiebo2010cx, Feb 15, 2007.

  1. xiebo2010cx Member

    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
    ------------------
  2. ndinakar Member

    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
    ***********************
  3. MohammedU New Member

  4. satya Moderator

    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.

Share This Page