Sample Header Ad - 728x90

Target server is not communicating(polling) with master SQL Server

1 vote
1 answer
662 views
We set up multi-server administration to create a job on the master which are executed on target servers, and we had this issue because the target server was shut down after a virus attack and we set up a new SQL Server with the same name and restore all data including the master database on the new server, all the job is functioning as it used to be but now the issue happened when I am trying to update them, I can update the job at master SQL Server to change the schedule however the target server is not updating since it stopped polling after the original old server shutdown because of the virus attack, Currently, the new SQL Server Agent is not showing (tsx) I tried to force poll but it's not working. my trial to add it as target server is not working with a duplicate error too. Also, my trial to update the job at the target server is not possible since it's not active to even update Please advise how can I reconnect this master and target server with out losing all jobs.
Asked by Liza (11 rep)
Dec 29, 2020, 11:53 PM
Last activity: Oct 28, 2024, 01:01 AM