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 Development (2000)  Transactional replication

Author  Topic  Anna Starting Member 20 Posts Posted - 2001-03-30 : 02:33:31 I have made a copy of the database I want to replicate on a separate server and have set it up as a push subscriber to my publisher. I have set the distibution agent schedule to run every minute (this is just a test using a small database). Everything seems to be running fine. Because I want the subscriber to be updateable if necessary, (its intended as a backup to the live), I made a copy of the live database, rather than take a snapshot. All the messages I'm getting back tell me that the whole thing is running fine, but when I add a record to a table in the publisher database, it never appears in the subscriber. I suspect I'm doing something wrong, probably at a very basic level - but I'm stuck! Is there a log somewhere that will tell me what's failing or is there a setting somewhere that I've missed? Any suggestions gratefully received! Anna