Mirroring disconnected.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Mirroring disconnected.

Mirroring disconnected.

Rate Topic

Display Mode

Topic Options

Author

Message

bhargavgampala

Posted Tuesday, November 30, 2010 2:17 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 12:52 AM
Points: 41, Visits: 152

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

Post #1027804

kapfundestanley

Posted Tuesday, September 13, 2011 3:53 AM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 1:47 AM
Points: 774, Visits: 1,047

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

Post #1173977

kapfundestanley

Posted Thursday, October 20, 2011 1:36 AM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 1:47 AM
Points: 774, Visits: 1,047

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

Post #1193379

« Prev Topic | Next Topic »

Permissions