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 |
|
Rully
Starting Member
4 Posts |
 Posted - 2008-05-22 : 09:31:31
|
| Dear All,I had problem about Replication like this,MSSQLSERVER - Replication- Replication Distribution Subsystem: agentA000S-ITPSS02-PSS4WMASTER-PSS4WMASTER_Publicati-A000S-ITPSS02-3 failed. The subscription(s) havebeen marked inactive and must be reinitialized. NoSyncsubscriptions will need to be dropped and recreated.what happen with my replication?and how to solve this problem?thanksRully |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-22 : 10:17:31
|
| Reinitialize the subscription. Your Subscription must be deactivated by distribution cleanup agent job. See sp_changedistributiondb in Books online to increase time. |
 |
|
|
|
|
|
Replication-failed