Mirror server RRS feed

  • Question

  • What is the difference between principal server and mirror server?

    Md. shams

    Sunday, November 10, 2013 9:28 AM


  • Principal is a primary server where resides the database which participates in mirroring.Primary  server that sends the modified records the mirroring server (where resides the copy of the principal database)


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Sunday, November 10, 2013 10:54 AM
  • What is the difference between principal server and mirror server?

    Md. shams

    As such it matter of failover which is primary and which is mirror .One major difference is primary database is one which is online and is talking to application while mirror server is one which is always in restoring state and trying to sync with Principal as close as possible,


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Sunday, November 10, 2013 11:24 AM
  • Principal server is the primary server. And mirror server is secondary one.

    Principal server sends the updated data to mirror server. And the mirror server data is updated.

    Principal server's data can be viewed any time. Mirrored database is not accessible.

    Sunday, November 10, 2013 11:26 AM

All replies