November 30, 2010 at 2:17 am
hi all,
mirroring disconnected it shows error in the log as
Error: 1474, Severity: 16, State: 1.
Database mirroring connection error 4 'An error occurred while receiving data: '64(failed to retrieve text for this error. Reason: 15105)'.' for 'TCP://........'.
Database mirroring connection is in Asynchronous mode
please help me..
how to establish the connection and resent the unsent log.
regards,
anjali
September 13, 2011 at 3:53 am
If the principals lose connection that is the state of the cause.If the connection is established the databases will revert to their normal states.Causes of that could be:
1.DNS server is down
2.Link between the principals is down
3.You change the user that is running sql services(to one that cannot run them)
4.SQL Server Agent is not running on either or both servers
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
October 20, 2011 at 1:36 am
If the link problem is resolved the database will came back online...synchronized.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply