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