Wednesday, February 27, 2013

Alter Database Mirroring endpoints


Hi , i was doing databases  mirroring with Witness set up in few  SQL server 2008 instances

I used to see lot of times Mirror in disconnected state., so when i went and saw at the SQL Error log on primary server i saw the message

"Database mirroring connection error 4 'An error occurred while receiving data: '64(The specified network name is no longer available.)'.' for 'TCP://wedcb469:5023'.
 I  was  able to connect Primary ,Witness and Mirror servers from all 3 servers but still mirror is in disconnected state.


Resolution to the above error is 
 


use master
GO
alter endpoint endpoint_name state = stopped;
GO
alter endpoint endpoint_name state = started;
GO


This solved my problem lot of times ...which also could help you in solving ..


Thanks

No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...