Database is in InRecovery - DB Mirroring RRS feed

  • Question

  • I am running Microsoft SQL 2008 R2 database server I have a mirrored database that shows in the following state 'databasename (Principal, Disconnected/In Recovery)'. When I look at the mirror server is shows in the same state 'databasename (mirror, Disconnected/In Recovery)'. I am not able to do anything with either DB, I cannot break the mirror, I can't take it offline, I cannot delete it.

    Now the problem is the particular database is removed from Mirroring. Is there any way to access the database Or take the data from database without configure mirroring again ??

    Wednesday, November 20, 2013 9:28 PM


  • Thanks Dimant.

    I removed the mirror using SET PARTNER OFF command.And i have restored the previous day backup.Then database came to Online. Now i am able to access the Database as standalone DB. But i cant get the all data.I have restored the previos night backup only.

    Is there any way to get complete the data???

    Vinodh Selvaraj

    Saturday, November 23, 2013 6:45 AM

All replies