Setting up a replication system  Chapter 3: Administering ASE Replicator

Chapter 2: Setting Up and Starting ASE Replicator

Uninstalling ASE Replicator

Use the following procedure to uninstall ASE Replicator.

StepsTo uninstall ASE Replicator

  1. Remove the secondary truncation point for each primary database. For example:

    1> use my_primary_db
    2> dbcc settrunc('ltm','ignore')
    
  2. Use sp_dropprimaryart to drop primary articles from publications.

  3. Remove sp_repmarker from each primary database.

  4. Remove the rl_lastcommit table from each replicate database.

  5. Remove sp_helpdb from the sysprocs database.

  6. Drop the distribution database.

  7. Remove ASE Replicator entries from the sysservers table.

  8. Remove ASE Replicator logins.

  9. Remove all ASE Replicator instance directories and any additional startup scripts.





Copyright © 2005. Sybase Inc. All rights reserved. Chapter 3: Administering ASE Replicator

View this book as PDF