none
Mirroring links RRS feed

  • Question

  • Can some body pls provide me interivew faqs on mirroring architecture ,mirroring setup,mirroring troubleshooting ?
    Tuesday, February 1, 2011 9:03 AM

Answers

  • If you had never configured/troubleshooted mirroring it is not going to help you in the interview....

    Lots of article you can dind on internet

    Recently SQL Server MVP Hilarry Cotter has summarized pros and cons of choosing mirroring

    ere are some cons.
    1) the database name on the mirror and principal must be the same
    2) the mirrored database on the principal must be and remain in full recovery model
    3) high log activity (defragging, reindexing, online indexing) may be difficult to mirror
    4) requires a stable network link and a network link with adequate bandwidth
    5) file paths should be the same on both the principal and the mirror - this is a concern if you add a file to a file group
    6) for some workloads high safety will add latency to the application and limit scalability.
    7) high performance is generally the best mode and is only available with the Enterprise Edition
    8) you never really know where you are with database mirroring - are you completely caught up? How far behind are you? Its had to get a firm handle on this with database mirroring
    9) you can only set up one mirrored pair, ie one database can be mirrored to one and only one mirror.

    Here are the pros
    1) relatively simple to set up
    2) can work well when you have adequate network bandwidth and your logging activity is average
    3) latency and your exposure to data loss can be minimal
    4) does automatic client redirection and failover
    5) failback is uncomplicated.


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, February 1, 2011 9:15 AM
  • in addition:-

    1. mirroring mode

    2. End Points

    3. asyncronous mirroring

    4. syncronous mirroring

    5. edition supported

    5. Mirroring configuration steps


    --------------------------------- Devender Bijania
    Tuesday, February 1, 2011 9:40 AM
  • Go though the following MSDN link .

    http://msdn.microsoft.com/en-us/library/cc917680.aspx

    _-----------------------------
    Thanks,Suhas V
    Tuesday, February 1, 2011 10:43 AM

All replies

  • If you had never configured/troubleshooted mirroring it is not going to help you in the interview....

    Lots of article you can dind on internet

    Recently SQL Server MVP Hilarry Cotter has summarized pros and cons of choosing mirroring

    ere are some cons.
    1) the database name on the mirror and principal must be the same
    2) the mirrored database on the principal must be and remain in full recovery model
    3) high log activity (defragging, reindexing, online indexing) may be difficult to mirror
    4) requires a stable network link and a network link with adequate bandwidth
    5) file paths should be the same on both the principal and the mirror - this is a concern if you add a file to a file group
    6) for some workloads high safety will add latency to the application and limit scalability.
    7) high performance is generally the best mode and is only available with the Enterprise Edition
    8) you never really know where you are with database mirroring - are you completely caught up? How far behind are you? Its had to get a firm handle on this with database mirroring
    9) you can only set up one mirrored pair, ie one database can be mirrored to one and only one mirror.

    Here are the pros
    1) relatively simple to set up
    2) can work well when you have adequate network bandwidth and your logging activity is average
    3) latency and your exposure to data loss can be minimal
    4) does automatic client redirection and failover
    5) failback is uncomplicated.


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, February 1, 2011 9:15 AM
  • in addition:-

    1. mirroring mode

    2. End Points

    3. asyncronous mirroring

    4. syncronous mirroring

    5. edition supported

    5. Mirroring configuration steps


    --------------------------------- Devender Bijania
    Tuesday, February 1, 2011 9:40 AM
  • Go though the following MSDN link .

    http://msdn.microsoft.com/en-us/library/cc917680.aspx

    _-----------------------------
    Thanks,Suhas V
    Tuesday, February 1, 2011 10:43 AM