SQL 2000 Transactional Replication

  • I am having issue where the data are not getting displayed on subscriber but are on publisher. so if i run query in query analyzer on publisher i see those records but same query run on Subscriber no results. i see the different in database size of 300MB so if my Publisher as 10500 then on subscriber the database size is 10200, as i am replicating all tables/articles so i am not missing any tables in replication. I don't have any disk space issue, nor my replication was broken or error out or stopped working. my Log Reader & Dist agents is working fine & none of my subscriber are expired. i am not seeing any errors. so any lead or directions will be highly appreciated. thanking you

  • Do not put too much time into why the databases are different sizes.  I do not know what you have set up for each of your articles, but replication does not have to include all (or any) indexes, and transactional replication does allow for your publisher and subscriber to expand their data files at different rates.

    If you are missing records in a particular table, you need to re-examine your replication settings.  Make sure there is no filtering.  Make sure there have been no replication errors in the error history, and finally check the SQL logs on the subscriber.

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply