January 16, 2009 at 2:32 pm
I am trying to replicate one database from SQL server 2000 to SQL Server 2008. The follow are the observations:
1. Snapshot job ran fine.
2. Distribution agent job failed: below is the error:
The replication agent encountered a failure. See the previous job step history message or Replication Monitor for more information.
The step failed.
I looked at the replication monitor, it does'nt say anything.
Any ideas!! Thanks.
January 17, 2009 at 9:10 am
Did you drill down in the monitor to the distribution agent itself, or to the subscriber? I've found it a little convoluted to try and reach any errors in the logs. The other thing is to open the job itself on the distribution server and look at the history on the failed step.
One other thing you can do, which might save you a great deal of time, run a query against the replication error table.
select * from --distribution database.--dbo.MSrepl_errors
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply