locked
MIrror database is in "synchoronizing" mode after restart RRS feed

  • Question

  • Hello All,

    I had restart my mirror server yesterday and after rebooting database status is "synchronizaing" which was "synchronized" before. My question is that normal or do I need to recreate the mirroring by restoring new datbase backup?

    I am using 2005 Enterprise edition on windows 2008 R1.

    Any help would be appreciate.

    Regards,

    Sunday, May 29, 2011 11:16 PM

Answers

  • You can also try to recycle the endpoints. I have seen behavoiur like this in SQL 2005 before. Cycling the endpoints normally is the easiest to try as it does not interrupt your operation. The commands would be:

    ALTER ENDPOINT <endpoint name> STATE=STOPPED

    ALTER ENDPOINT <endpoint name> STATE=STARTED

    You get the endpoint name in SSMS under Server Objects -> Endpoints -> Database Mirroring

     

    Lucifer

    Tuesday, May 31, 2011 6:54 AM

All replies

  • Hi Hellozishan!

    This behaviour is normall as  after startup SQL Server needs to push everything that has happened during the downtime of the server over. This should not take too long though, normally the DBs are back to "Synchronized" within a few minutes.

    Lucifer

    Monday, May 30, 2011 5:55 AM
  • Hi Prince,

    But now its more than 24 hours. Is there any way that I can check theses database are still in mirror or do I need to re-establishing the mirroring.

     

    Regards,

     

    Monday, May 30, 2011 6:17 AM
  • Whats the output of Select @@version.

    There have been many fixes in database mirroring. They are listed here
    http://blogs.msdn.com/b/arvindsh/archive/2010/12/22/db-mirroring-tips.aspx
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    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
    Monday, May 30, 2011 6:49 AM
  • It normal for few minutes not but 24 hour is out of acceptable range.

    Definitely some problem with your network. Please check with mirroring monitor how much contents of the mirror database are lagging behind the contents of the principal database.

    What is your database size? If it is feasible size then would suggest you to re-initialise your mirroring.

     


    http://uk.linkedin.com/in/ramjaddu
    Monday, May 30, 2011 1:56 PM
  • You can also try to recycle the endpoints. I have seen behavoiur like this in SQL 2005 before. Cycling the endpoints normally is the easiest to try as it does not interrupt your operation. The commands would be:

    ALTER ENDPOINT <endpoint name> STATE=STOPPED

    ALTER ENDPOINT <endpoint name> STATE=STARTED

    You get the endpoint name in SSMS under Server Objects -> Endpoints -> Database Mirroring

     

    Lucifer

    Tuesday, May 31, 2011 6:54 AM
  • Yes agree with PrinceLucifer,

    also Please check under what account endpoints are configured? It is account status is active ?

    Any passwords expired or passwords changes happened on the account?

     


    http://uk.linkedin.com/in/ramjaddu
    Tuesday, May 31, 2011 10:35 AM