Database is stuck in Principal, Disconnected,In Recovery... RRS feed

  • Question

  • Hi Msdn,

    After a network issue, mirror server and instance is unavailable(to check mirror status). Principal server database state is in Principal, Disconnected,In Recovery..., I am unable to pause or remove mirroring from database properties, coz unable to find any option here. How can I remove mirroring for this database temporarily to avoid log file filling up?


    • Edited by Adi9032 Sunday, February 24, 2019 1:09 PM
    Sunday, February 24, 2019 1:08 PM

All replies

  • Hi Adi9032,

    You can remove database mirroring from a database by using SSMS or Transact-SQL. Please refer to Remove Database Mirroring (SQL Server).

    Best Regards,
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, February 25, 2019 1:31 AM