December 5, 2007 at 7:24 am
I recently found out I am responsible for a SQL Server2005 set of databases with high saftey mirroring(no witness). The databases are for our MOSS(Sharepoint) application. The current state of the primary is active and functioning normally except for the disconnected mirrror. I know that mirroring was working for a week or two before the mirror server experienced a number of different problems and errors that finally forced our systems group to apply some maintenance and re-boot the server. The errors stopped except one new one about the mirror and the mirror never reconnected. The error is essentially is that the certifiaction file on the mirror is not found "State 89". After troubleshooting the error I know that the certificate file is exactly where it has always been on both the primary and mirror servers and that they match and they both have the begin and expiration dates set. One question I have about the certificate is does it have to be "installed". I know that the SQL services on both servers for the SQLserver instance, agents and the browser are started( I even re-started them just in case). I know that network connectivity between the servers is good. One error that concerns me is "error:955, the instance is unavailable, the database cannot be opened." when I try to use the management console to explore the databases on the mirror. From looking at the logs it appears that mirroring has been disconnected about three months and the primary logs are close to critical mass. Is there something(s) I can do to re-connect the mirror or am I stuck with removing the mirrror and rebuilding it? I have attached an excerpt from our log file covering the days of problems prior to the server re-boot.
December 5, 2007 at 9:20 am
it looks like it was failing and recovering alot before the reboot.....
however, it seems to have always recovered.
You should be able to just stop mirroring and delete all references to the end points and recreate.
If your mirror is still in 'recovering' mode, then you will not have to re-do mirroring from scratch.
December 5, 2007 at 11:36 am
Thanks for the help.
Is "Stop mirroring" the same as the REMOVE button on the management console or the command ALTER DATABASE [ ] SET PARTNER off????
December 5, 2007 at 11:51 am
no, its not the same.
you want to remove. you shouldn't have to stop since it is not running anyways.
after you remove, browse to the objects called EndPoints in Management Studio and manually delete those entries.
Then start the mirroring wizard.
This is what I have done several times in the past.
December 5, 2007 at 12:07 pm
You are referring to doing this on the primary, correct??
December 5, 2007 at 12:20 pm
the removing happens there. the Endpoints would be at both instances.
December 5, 2007 at 12:22 pm
Got it. Thank you, very much.
December 6, 2007 at 7:52 am
The "remove mirroring" and deleting endpoints worked just fine. I thought of one more question. Do I have to re-establish my mirror and let the mirror synchronize before I can truncate and shrink my primary log?
December 6, 2007 at 9:46 am
yes.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply