RE: convert replica

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul Sanguinetti (PaulSanguinetti_at_discussions.microsoft.com)
Date: 12/06/04 

Date: Mon, 6 Dec 2004 06:41:03 -0800

When all else fails, try creating a new database. Import all
forms/macros/reports/modules etc. Then create links from the new database to
the old database. Finally, use create table queries to copy the data fields
from the old database to the new database. Don't use "Select *" as that will
also copy the replication information and you will still have the problems
associated with a replica. You'll have to select each valid data field
individually in the query. After you've finished copying a table, delete the
link to the old table and rename the new table to the proper (old) table name.

Its tedious, but the only way to convert a replicated database to a simple
non-replica.

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: 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)
  • 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)