July 27, 2009 at 6:09 am
I'm attempting to restore mirroring to our production databases. When using the Wizard, I have completed all the steps I used last time (successfully) but after clicking on the "Start Mirroring" button, an error occurs saying that the Alter failed for database, exception occurred while executing a Transact-Sql statement, and the database is not configured for mirroring.
I'm sure I've missed something but I have print screens of all the settings I used last time, which aside from the actual server names used the default settings in the Configuration Wizard.
Any thoughts or suggestions would be appreciated!
Kay
July 27, 2009 at 11:37 am
This issue has been resolved.
For the benefit of others who may encounter the same issue, these are the steps that lead to a successful reconfigure of our mirrored database:
Servers involved -
Server1 (principal)
Server2 (mirror)
Server3 (witness)
On the principal database, took a full backup and then a transaction log backup.
On the mirror database, restored the full principal backup (NORECOVERY) and then the transaction log principal backup (also NORECOVERY.)
On the principal database, right-clicked and selected "mirror". Used the wizard to configure the three servers as normal.
I believe the key to what I did wrong was not applying both a full and then a transaction log backup (I tried doing this only from a full backup) and leaving the database in the "recovering" state.
One thing odd that occurred is that at on the "Complete the Wizard" screen, the witness server shows "Role: All" instead of "Role: Witness" and I don't understand why that occurred. I expected the role to be "Witness" and through the wizard there is no opportunity to edit that value. If anyone understands that setting or the implications of it being set to "All" instead of "Witness" please let me know.
Thanks,
Kay
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply