locked
MIrroring on SQL 2012, neither database available no errors thrown RRS feed

  • Question

  • Recently implemented mirroring for a small database on SQL 2012. Everything is generally working well. one day with no warning, both databases went to a status of (Mirror, Synchronized/Restoring) and the database was unavailable.

    If forced the principal back online and everything returned to normal.

    There were no log entries in SQL or in the Mirror monitor logs to indicate the cause for this.

    I have no idea if this will ever happen again or how I can troubleshoot.  I find nothing online that describes this scenario

    Any help would be most appreciated

    Thanks


    DWM

    Tuesday, November 11, 2014 9:22 PM

Answers

  • Clearly this was anomaly, never occurred again

    DWM

    • Marked as answer by Devin McMahon Thursday, August 20, 2015 6:41 PM
    Thursday, August 20, 2015 6:41 PM

All replies

  • There should be some error messages... check the erorr log, eventlog, for sure there should be something...

    here is the possible failures... and there may be few more as well... just check the below link... can help much without capturing spcific error message....

    http://msdn.microsoft.com/en-us/library/ms190913.aspx


    Raju Rasagounder Sr MSSQL DBA

    Wednesday, November 12, 2014 12:35 AM
  • >>>If forced the principal back online and everything returned to normal.

    Have you ran ALTER DATABASE mirrored_database SET PARTNER FAILOVER?

    Have you checked Event Viewer for the errors?


    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

    Wednesday, November 12, 2014 6:48 AM
  • You should have some errors, could you check sql error log.

    By any chance you are running in High Performance Mode (Asynchronous) with Witness?


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    Wednesday, November 12, 2014 11:10 AM
  • Thank you for all the input.  I will review everything mentioned and report the results


    DWM

    • Marked as answer by Devin McMahon Thursday, August 20, 2015 6:40 PM
    • Unmarked as answer by Devin McMahon Thursday, August 20, 2015 6:40 PM
    Wednesday, November 12, 2014 3:01 PM
  • Clearly this was anomaly, never occurred again

    DWM

    • Marked as answer by Devin McMahon Thursday, August 20, 2015 6:41 PM
    Thursday, August 20, 2015 6:41 PM