locked
synchronizing/restoring RRS feed

  • Question

  • i have two servers which are mirrored. one of the databases on the servers are stuck in recovery, so one database says "synchronizing/restoring" and the other says "In recovery", how do i fix this??? i read some threads and most pointed to a space issue...but i'm looking at all of my drives and they all have atleast 100GB free (am i looking the wrong place for the size? maybe they were talking about another size not the physical disk drive?). put screen shot below. please help

     

     

     

     

     

     

     

    Thursday, December 1, 2011 3:40 PM

All replies

  • Can you please post the messages from the SQL errorlog?
    Friday, December 2, 2011 7:09 AM
  • Please post the error log!

     


    Nareshkar Pakanati 

    MCTS, MCITP SQL Server 2008 Admin
    My Blog: www.mssqlfix.com
    Twitter: @mssqlfix
    -------------------------------------------------------
    Please mark the post as Answered if it answers your question.
    -------------------------------------------------------
    Wednesday, December 14, 2011 8:55 AM
  • Hello,

    You were able to fix this one? Or still facing issues?

    Thank you,


    Anup | Forum Support| If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer.
    Wednesday, December 14, 2011 10:16 PM
  • In addition, what does the below query return?

    SELECT name,log_reuse_wait_desc FROM sys.databases


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Thursday, December 15, 2011 6:39 AM