June 4, 2010 at 10:03 am
Okay, one of our rack servers that serves as a mirror server has apparently died. Trying to determine if Network Services can simply replace appropriate hardware and restart the server that way, or if it will need to be rebuilt from scratch, including reinstalling OS, SQL Server, etc.
If that is the case, I could use a little guidance on the mirror side.
Will I need to break the mirror to the currently non existant mirror server?
Do I need to break the connection to the witness server as well?
Any tips, suggestions, guidance is definately welcome at this point, as I'm not sure which way we are going at the moment, so more information the better.
June 4, 2010 at 11:30 am
Disaster alleviated. Turns out some memory went south. SysAdm replaced all the RAM in the server (resulted in an upgrade from 20GB to 24GB) and it is up and running!
June 4, 2010 at 12:32 pm
I had a similar problem a few years back (SQL Server 2005). For me the solution was to remove the mirroring from the principal, restore the database to the mirror and set up the mirroring from scratch again. All 3 servers (Principal, Mirror and Witness) were at the same site so it was easiest route for us.
I'm curious to see what others would do in this situation or if there is a better method.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
June 4, 2010 at 12:50 pm
I'm assuming that this meant dropping both the partner and witness servers from the principal database, correct?
June 4, 2010 at 1:49 pm
Yes.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
June 27, 2010 at 11:45 pm
If your mirroring is configured for high safety mode safety = full with witness server configured, and if your mirror fails you should not remove the connection between witness server and principal server. This will stop the principal server from not responding to client connections.
This might explain you more in detail.
http://msdn.microsoft.com/en-us/library/ms189902.aspx
Thanks,
Dhanalakshmi
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply