locked
Mirroring with a Witness server using Certificates RRS feed

  • Question

  • Hi everyone, You folks have helped me so much I just wanted to say Thank You.  My question is when using certicates for mirroring how long before they expire. And when they do how will that affect the mirroring session. i.e. do I have to recreate the mirrored DB from a production backup or will the mirroring session catch up. Thanks

    -Chris

    Monday, September 20, 2010 5:24 PM

Answers

  • Chris

    Can you elaborate a little bit what  you are trying to achive? How do you plan using certificates with a mirroring? With mirroring SQL Server transfers only modified rows from the principal to the mirror server


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by cRu12 Wednesday, September 22, 2010 7:00 PM
    Tuesday, September 21, 2010 6:05 AM
  • Hey Chris,
    As Uri mentioned, we need clarity on question.

    If you want to know how to use ceritificate for mirroring, this link would help.
    http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx


    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    • Marked as answer by cRu12 Wednesday, September 22, 2010 7:00 PM
    Tuesday, September 21, 2010 8:17 AM
  • By default, certificates used for database mirroring have an expiry of one year. You can change that in the CREATE CERTIFICATE command using the EXPIRY_DATE option
     
    If your certificate expires while your database mirroring is running, you won't have any issues provided you don't restart your SQL Server instance. If you do, you'll get the error message below
    -------------------------------------------------------------------------------------------------------------------
     
    Database Mirroring login attempt failed with error: 'Connection handshake failed. The certificate used by this endpoint was not found: Certificate expired. Use DBCC CHECKDB in master database to verify the metadata integrity of the endpoints. State 85.'

    bass_player http://bassplayerdoc.blogspot.com/
    • Marked as answer by cRu12 Monday, September 27, 2010 6:29 PM
    Thursday, September 23, 2010 9:01 PM

All replies

  • Chris

    Can you elaborate a little bit what  you are trying to achive? How do you plan using certificates with a mirroring? With mirroring SQL Server transfers only modified rows from the principal to the mirror server


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Marked as answer by cRu12 Wednesday, September 22, 2010 7:00 PM
    Tuesday, September 21, 2010 6:05 AM
  • Hey Chris,
    As Uri mentioned, we need clarity on question.

    If you want to know how to use ceritificate for mirroring, this link would help.
    http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx


    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    • Marked as answer by cRu12 Wednesday, September 22, 2010 7:00 PM
    Tuesday, September 21, 2010 8:17 AM
  • By default, certificates used for database mirroring have an expiry of one year. You can change that in the CREATE CERTIFICATE command using the EXPIRY_DATE option
     
    If your certificate expires while your database mirroring is running, you won't have any issues provided you don't restart your SQL Server instance. If you do, you'll get the error message below
    -------------------------------------------------------------------------------------------------------------------
     
    Database Mirroring login attempt failed with error: 'Connection handshake failed. The certificate used by this endpoint was not found: Certificate expired. Use DBCC CHECKDB in master database to verify the metadata integrity of the endpoints. State 85.'

    bass_player http://bassplayerdoc.blogspot.com/
    • Marked as answer by cRu12 Monday, September 27, 2010 6:29 PM
    Thursday, September 23, 2010 9:01 PM