Secondary database was showing INRECOVEY

Question

Hi Team,

I am configuraring database mirroing in server A to Server B here

Sever B is showing In Revoery

I have tried in the below to bring in normal mode

Restore Database xxx with Recovery

but here it is giving below Error

Msg 3104, Level 16, State 1, Line 1

RESTORE cannot operate on database 'Trace' because it is configured for database mirroring. Use ALTER DATABASE to remove mirroring if you intend to restore the database.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

---

subu

Answer 1

Hello,

Could you give us the background detail of what happened? Was there a failover and the database didni't recover? What safety level of mirroring was used? Are you trying to get rid of mirroring on that database and recover it as is? Are you still trying the initial setup of database mirroring?

If you are just trying to drop mirroring and recover the database you can use the following:

ALTER DATABASE Trace SET PARTNER = OFF
GO

RESTORE DATABASE Trace WITH RECOVERY
GO

If you don't want to destroy the mirroring of the database please give us some more information so we can help you out.

-Sean

Answer 2

Hi Team,

database was in recovery mode

I have tried using  below command

RESTORE DATABASE Trace WITH No RECOVERY

after the database showing restoring mode.

next i have restored tha database next t-log also next i have configured mirroring it is working fine

Thanks your help sean.

---

subu