motioneye
asked on
sql2008 pull subscription error
Very often we received this error messages , but it will works fine after we restart distribution agent, any ideas what is this error message about and what is the resolution to this error
Source: Failed Command
Number:
Message: {call sp_MSget_subscription_guid (3)}
2013-05-09 17:04:06.132 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 64
Message: TCP Provider: The specified network name is no longer available.
2013-05-09 17:04:06.134 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 64
Message: Communication link failure
2013-05-09 17:04:06.237 The agent failed with a 'Retry' status. Try to run the agent at a later time.
Source: Failed Command
Number:
Message: {call sp_MSget_subscription_guid
2013-05-09 17:04:06.132 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 64
Message: TCP Provider: The specified network name is no longer available.
2013-05-09 17:04:06.134 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 64
Message: Communication link failure
2013-05-09 17:04:06.237 The agent failed with a 'Retry' status. Try to run the agent at a later time.
Try to drop and add back the subscriber.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.