March 18, 2009 at 7:13 am
Hi All,
I have set mirroring on sql server 2005. It seems to be working, however from time to time "out of nowhere" status of mirroring database changes to suspended. Do you have any ideas, what can be the cause of this?
I am using witness.
Regards
March 18, 2009 at 6:59 pm
One reason is extended communication failure between the two nodes; the node could not talk to its partner/witness so could not decide if it should take over the principle roll. To protect the database it put itself in suspended mode.
Are there any errors in system events/sql logs?
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply