Remove Replication from Database (URGENT - PLEASE HELP)

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: paul goldney (paulg_at_wizardit.co.uk)
Date: 11/30/04

  • Next message: Weste: "Re: Is Replication Advisable Under This Scenario?" 
    Date: 30 Nov 2004 05:15:41 -0800

    I have a database which has been replicated many times

    I am now installing to a new standalone customer but have all these
    table aonflict.....etc..

    Obviously left over from replication of some sort

    I have used sp_removedbreplication but this didnt seem to do anything
    They are listed as system tables

    I think the fact that these are there are causing me some other
    strange problems
    If I have the database on MSDE it works fine saving into 1 table, if
    on Full Blown SQL I get issues inserting records into 1 table

    Strange - Please advise on best way of removing these tables

    Regards Paul

  • Next message: Weste: "Re: Is Replication Advisable Under This Scenario?"

    Relevant Pages

    • Re: Errors in Directory Service Event Viewer
      ... >condition persists then please restore the database from a previous backup. ... >following directory partition. ... >Sites and Services for the KCC to create a spanning tree replication ... >- Add a Connection object to a domain controller that contains the directory ...
      (microsoft.public.windows.server.active_directory)
    • Errors in Directory Service Event Viewer
      ... Event Category: Database Page Cache ... following directory partition. ... Sites and Services for the KCC to create a spanning tree replication ... - Add a Connection object to a domain controller that contains the directory ...
      (microsoft.public.windows.server.active_directory)
    • Re: Replication/Sychronization and security
      ... When put on the network it takes several seconds for those close to ... I am told that our network drives are for data storage (word/excel ... explore the possiblity of replication as a solution. ... >> database to decrease the potential for breach. ...
      (microsoft.public.access.replication)
    • Re: Need help determining where the problem is in my AD replicas
      ... I would demote and promote Education make sure you get a full backup though. ... > Event Source: NTDS Replication ... > changes received from the following source domain controller. ... > 8451 The replication operation encountered a database error. ...
      (microsoft.public.windows.server.active_directory)
    • Re: AD Replication
      ... Source NTDS Replication ... A database error occurred while applying replicated changes ... On the source domain controller, move the object to have a ... If the error is occurring in an application partition, ...
      (microsoft.public.windows.server.active_directory)