Database mirroring connection errors

I'm currently using database mirroring as a hot-standby, without a witness. Everything appears to be running fine, but I'm receiving intermittent errors that appear to state that my servers are loosing connectivity, thus disabling (inactivating) the mirror until the connection has been reestablished.

The errors are listed below, basically, I note a block of log entries for each mirrored database stating that mirroring is inactive for the database(s), next Error 1474, next the connection error, then another block of log entries for each mirrored database stating that the mirroring session is once again active.

Database mirroring is inactive for database 'NetRS'. This is an informational message only. No user action is required.

Error: 1474, Severity: 16, State: 1.

Database mirroring connection error 4 '64(The specified network name is no longer available.)' for 'TCP://SQL01NRS:7024'.

Database mirroring is active with database 'Telephony' as the principal copy. This is an informational message only. No user action is required.

I have confirmed that the sessions are in sync, so am not concerned about the data - but would love to get rid of these errors / disable / enable. I'm assumming that if I had setup a Witness, that I would see the mirrored database flip-flopping back and forth between Principal and Mirror.

Please let me know if I can provide any additional details to assist ...

Hi,

What build (service pack) of SQL Server you are runnng.

Check the following link if any of this applies to your situation.

http://support.microsoft.com/kb/912422

Jag

|||

Edition and Build Information on server acting as Principal

Enterprise Edition 9.00.2047.00

Edition and Build Information on server acting as Mirror

Enterprise Edition 9.00.2047.00

|||

Jag:

Thanks for your inquiry and feedback. I looked over the article that you referenced, and appears that this might be applicable. We are running a Synchronous mirroring session without a Witness. Unfortunately, we are running SP1, and this issue appears to have been resolved with SP1. Any ideas?

|||

Hi,

If there are no other errors in SQL server error log, then its possible that the problem is likely to be the windows server or the network.

Error 64 is a windows error.

Check the following:

http://support.microsoft.com/kb/888319/en-us

regards

Jag

Database Mail errors

This summary is not available. Please click here to view the post.

Database Mail errors

Hi,
I thought that I had configured Database Mail correctly but I am getting
this message:-
Message
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 1 (2006-08-30T11:36:43). Exception
Message: Cannot send mails to mail server. (Failure sending mail.).
)
What is causing this?
Thanks
ChrisI am also getting this error on my Win2k3 Server with Sql 2005
installed. I can ping mail.xxx.com, I haven't tried using OE or
Outlook, but this is one server on a whole network of people sending
mail via SMTP to our WIN2kServer running 3rd party mail server software
that allows relay from internal IP's. I also have another SQL server
with the same problem. This leads me to think that there is something
on the Server's that I am not doing properly. I see a lot of post for
people who have resorted to using 3rd party apps and CDO because this
apparently doens't work for a lot of people... Any ideas or help?
Thanks all
Chris Wood wrote:
> Hi,
> I thought that I had configured Database Mail correctly but I am getting
> this message:-
> Message
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 1 (2006-08-30T11:36:43). Exception
> Message: Cannot send mails to mail server. (Failure sending mail.).
> )
> What is causing this?
> Thanks
> Chris|||John,
We are trying to use the SQL Server machine itself to send the mail and this
does not work. If we do not want to use our Exchange server then do we need
a server dedicated to just relay SMTP traffic?
Thanks
Chris
<john.dean@.gmail.com> wrote in message
news:1157553993.669998.218770@.m79g2000cwm.googlegroups.com...
>I am also getting this error on my Win2k3 Server with Sql 2005
> installed. I can ping mail.xxx.com, I haven't tried using OE or
> Outlook, but this is one server on a whole network of people sending
> mail via SMTP to our WIN2kServer running 3rd party mail server software
> that allows relay from internal IP's. I also have another SQL server
> with the same problem. This leads me to think that there is something
> on the Server's that I am not doing properly. I see a lot of post for
> people who have resorted to using 3rd party apps and CDO because this
> apparently doens't work for a lot of people... Any ideas or help?
> Thanks all
>
> Chris Wood wrote:
>