none
SQL mirror witness server lost in configuration RRS feed

  • Question

  • Hello,

    I have encountered an issue in SQL 2008 R2 where the Witness Server is being wiped out of the mirroring configuration.  I can go in and reconfigure mirroring with the Witness server and the information is retained for a period of time, and then out of the blue, it is gone (we may be talking a period of months). 

    The principal and the mirror remain in tact, but the Witness information is gone.  I am relatively confident nobody is removing it and can't find any KB's which spell out this issue.  Has anybody else encountered such an issue and been able to resolve it?

    Tuesday, January 8, 2013 5:30 PM

Answers

  • Hi,

    Is any error reported.



    Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

    Waqas

    MS(SPM), MS(E&F), MCP, MCT, MCTS, MCITP, MCSE, MCPD, MCSD, MCDBA , Author
    Twitter: @waqas8777
    Linked In: http://www.linkedin.com/in/waqasm1

    • Marked as answer by shageman0304 Sunday, July 20, 2014 4:32 PM
    Wednesday, January 16, 2013 4:42 AM

All replies

  • No I have not seen this issue, in order to re-configure Witness server you would need to break a mirroring, if you are lucky PrinceLucifer will jump in to provide more accurate suggestion...

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

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance

    Wednesday, January 9, 2013 6:02 AM
  • Hi,

    You need to break mirror and create again in order to reconfigure witness server.



    Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

    Waqas

    MS(SPM), MS(E&F), MCP, MCT, MCTS, MCITP, MCSE, MCPD, MCSD, MCDBA , Author
    Twitter: @waqas8777
    Linked In: http://www.linkedin.com/in/waqasm1

    Friday, January 11, 2013 7:28 AM
  • OK, but my issue is my witness is eventually lost or gone from the configuration.  So, I can break and establish just fine.  But, after a sustained period of being online, the witness is no longer present in the configuration.
    Saturday, January 12, 2013 12:04 AM
  • Hi,

    Is any error reported.



    Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

    Waqas

    MS(SPM), MS(E&F), MCP, MCT, MCTS, MCITP, MCSE, MCPD, MCSD, MCDBA , Author
    Twitter: @waqas8777
    Linked In: http://www.linkedin.com/in/waqasm1

    • Marked as answer by shageman0304 Sunday, July 20, 2014 4:32 PM
    Wednesday, January 16, 2013 4:42 AM