quinta-feira, 23 de fevereiro de 2012 14:29
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.
Todas as Respostas
quinta-feira, 23 de fevereiro de 2012 15:23Usuário que responde
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.
- Editado Sean GallardyMicrosoft Community Contributor, Editor quinta-feira, 23 de fevereiro de 2012 15:23
- Marcado como Resposta subu999 quinta-feira, 23 de fevereiro de 2012 15:44
quinta-feira, 23 de fevereiro de 2012 15:47
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.