sql server 2000 transactional replication help
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
I have a fairly large database which we replication (transactional
replication) to an offsite server.
nightly snaphot. log reader runs all the time. REPL distribution agent runs
every 15 mins.
trying to add a new table (or article) to the publication.
I must have done something wrong because it won't replicate!
I shows in my publication as a published article and it exists on the
subscriber server database - with no data.
Last night I used sp_droparticle to drop it from my subscription and then
waited a cycle for my repl agent to run. then I added it back in via ENT
MGR. then I did a snapshot and ran my REPL distribution agent.. still won't
replicate this one article!!!!?? what am I doing wrong!!!??
.
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) |
|