Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kingsofconveience
Starting Member
1 Post |
 Posted - 2009-10-03 : 03:28:17
|
| We have upgraded the SQL server from 2000 to 2005. After upgrade the replication is not working with the following symptoms:1. Subscription status always show 'Not running, performance critical'.2. When I try to re-sychronize with option "Start Synchronziing" , error is encounter as below :Replication montior could not start the job '..................'Additional informtion :SQL server Agent error : request to run job STX-T01-STL_NEwCC(from User sa) refused because the job is already running from a request by User sa. (Microsoft SQL Server , Error: 22022)Anyone could kindly help ? Or any idea to further troubleshoot this issue ?Thanks and best regards, |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-10-17 : 22:27:36
|
| I would've scripted and recreated the publications at time of upgrade. May need to do that now, but start by restarting the distributor and publisher. |
 |
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2009-11-04 : 03:43:02
|
| SQL 2000 replication scripts works good for migration to 2005. For performnace Critical, you could try changing the default profile, in publisher proiperties, especially if it is merge replication.Thanks,Krishnawww.SQLServer.in |
|
|
|
|
|
|
replication issue (log reader agent is not running