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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 replication snapshot fails

Author  Topic 

arunsqladmin
Yak Posting Veteran

74 Posts

Posted - 2010-05-03 : 23:50:41
We have a database tables replicated from one server to other and we are running snapshot replication of two tables with filtered rows but the replicated data does not limit the rows and publishes many unwanted rows. the SQL Agent show job with a (red X) and say the job failed and the job

category shows [UNCATEGORIZED(LOCAL)]
owner show as 'SA'

pl help

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-03 : 23:59:25
Check replication monitor for the reason why it failed.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -