I stopped the replication of a SQL 7.0 database (100 MB) for a few months. Now I want to restart it. What I did were: deleted the existing publication and re-created a new one using “Create and Manage Publicaton…” menu. Recreation was successful, but replication could not continue due to an error during the “initializing…” phase of the “Log Reader”. Err Msg: “The process could not initialize replication counters”. It may be resulted from the size of the Transaction Log (1.3GB). Prior to stopping the replication, the size was 5 MB. Using “Truncate Transaction Log” did not decrease the size. I was trying to detach the database so that I could recreate a new database with the same name and start replication again, but the deletionfailed because the database is still marked as published. My goal is to restart the replication of the original or start a replication of a new database with the same name as the original. Please help.
