We are moving our data layer from a 32-bit SQL 2005 cluster to a 64-bit SQL 2005 stand-alone. In order to minimize downtime of our production environment, I setup mirrors for the production databases with the 32-bit cluster being the principal, and the 64-bit stand-alone being the mirror. I was able to setup the mirrors without incident. Now in order to test the switch over, what I wanted to do was stop the mirroring and bring the dbs on the mirror up to a recovered state, then repoint our test application servers/DSNs/web sites at the 64-bit server to see what we could expect before go live in production.
When I stopped the mirror on one of the dbs, then disconnected/reconnected to the 64-bit system, the database is in a state of 'Recovering'. Is there a command that I need to use to get this db back to a usable state? At this time, I am unable to detach/reattach as the command is grayed out. I was able to stop the mirroring on another db, then I quickly detached and was able to reattach, but I'm not sure why I was able to do this.
Thanks in advance!
Start Free Trial
