locked
Mirroring possible failures and steps to resolve? RRS feed

  • Question

  • Hi All,

    We have a strange requirement from one of our client. Exactly saying before configure mirroring as a high availability he wants to know what would be the possible failures can occur in mirroring and how to resolve them. I believe it is hard to have a reported document of it but I'm really grateful if you can share your personal experiences to help me out on this.

    To achieve this I need simple scenarios or issue and steps to resolve it. Thank You.

    Regards,

    Kalyan


    ----Learners Curiosity Never Ends----

    Wednesday, January 22, 2014 2:45 PM

Answers

  • Most common problem is space issue and network problem. 

    http://technet.microsoft.com/en-us/library/ms190664(v=sql.100).aspx

    http://sqlbie.wordpress.com/2013/01/17/troubleshooting-database-mirroring-connectivity-issues/

    I would say, you understand the need of setting a database mirroring with your environment underlying infrastructure

    http://www.extremeexperts.com/sql/articles/DBMirroring2.aspx

    http://msdn.microsoft.com/en-us/library/ms189127(v=sql.100).aspx

    -Prashanth

    • Proposed as answer by Shanky_621MVP Thursday, January 23, 2014 6:28 AM
    • Marked as answer by Sofiya Li Monday, February 3, 2014 1:56 AM
    Wednesday, January 22, 2014 4:31 PM
  • he wants to know what would be the possible failures can occur in mirroring and how to resolve them.

    >>Is that mean during the deployment or after the deployment, if during the deployment means -prashanth provided link gives you the information.

    incase of after configuring to know any reason for failure failures-

    you cannot say exactly,need to look out the errors in the errologs& eventlogs for the same before analysing-

    addition to the above you can aslo refer-

    Possible Failures During Database Mirroring
    http://technet.microsoft.com/en-us/library/ms190913.aspx

    Troubleshooting Database Mirroring Error 1418
    http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    • Marked as answer by Sofiya Li Monday, February 3, 2014 1:56 AM
    Thursday, January 23, 2014 3:16 PM

All replies

  • Most common problem is space issue and network problem. 

    http://technet.microsoft.com/en-us/library/ms190664(v=sql.100).aspx

    http://sqlbie.wordpress.com/2013/01/17/troubleshooting-database-mirroring-connectivity-issues/

    I would say, you understand the need of setting a database mirroring with your environment underlying infrastructure

    http://www.extremeexperts.com/sql/articles/DBMirroring2.aspx

    http://msdn.microsoft.com/en-us/library/ms189127(v=sql.100).aspx

    -Prashanth

    • Proposed as answer by Shanky_621MVP Thursday, January 23, 2014 6:28 AM
    • Marked as answer by Sofiya Li Monday, February 3, 2014 1:56 AM
    Wednesday, January 22, 2014 4:31 PM
  • Simple someone shuts down the service...power failure....

    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

    Thursday, January 23, 2014 6:24 AM
  • he wants to know what would be the possible failures can occur in mirroring and how to resolve them.

    >>Is that mean during the deployment or after the deployment, if during the deployment means -prashanth provided link gives you the information.

    incase of after configuring to know any reason for failure failures-

    you cannot say exactly,need to look out the errors in the errologs& eventlogs for the same before analysing-

    addition to the above you can aslo refer-

    Possible Failures During Database Mirroring
    http://technet.microsoft.com/en-us/library/ms190913.aspx

    Troubleshooting Database Mirroring Error 1418
    http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    • Marked as answer by Sofiya Li Monday, February 3, 2014 1:56 AM
    Thursday, January 23, 2014 3:16 PM