SQL Server Performance

SQL server replication

Discussion in 'General DBA Questions' started by NewDBA, Jan 31, 2003.

  1. NewDBA Member

    Hi
    I removed replication
    And try to recreate it .
    It keep asking me about DTS package
    Before i never sow that wizard.
    Did replication removal not went correctly
    Thank you
  2. bradmcgehee New Member

    You might check to see if there are any DTS packages, and if so, you might want to delete them and see what happens. If this doesn't work, you may want to consider uninstalling and reinstalling SQL Server, if that is practical.

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  3. tkelley New Member

    This isn't the first post I've seen where DBAs remove replication and have problems. It's really important to remove replication in a certain way. Search MSDN for the proper method. When I first removed replication, I started deleting subscriptions individually and deleting Agent jobs, etc. BIG mistake!

    Some SQL books walk you through the process of removing replication, too.

    Good luck!

    Here is an excerpt from MSDN to give you an example:

    "Deleting articles from publications that have subscriptions is not allowed. To delete an article, you must first delete all subscriptions to the publication."




    ----------
    T Kelley
    MS, MCDBA, OCA, CIW

  4. satya Moderator

    Valid tip by Kelly, you should spare time to see BOL for replication topics which covers the required information.

    Satya SKJ

Share This Page