Can someone tell me where I can get some sample replication scripts for all the 3 replication types. Thanks in advance, Sastry ...more >>

I have seen a lot of issues about replication and SQL 2k sp3. I'm in planning to migrate a mission critical app that uses Merge replication to SQL 2k sp3. Should I go on or is better I wait hot fixes or apply only sp2 ? ...more >>

I am trying to replicate tables and data which belong to a specific user. Unfortunately, when the Merge synchronization runs, it creates new tables owned by dbo on the subscriber, instead of the correct username as it is on the publisher. How do I resolve this? FYI - When I run the sn...more >>

Hello, I am new to this and would like some assistance please. I have two db in the same SQL Group on a SQL 2000 installation. Both have an identical structure but different names. What I would like to do is syncronize some of the information from one db into the other on a daily basis, o...more >>

Hello all! I am going thur the replication wizard to config/create the distribution environment but keep failed on config distribution and distribution database is not created?? Any ideas? Thanks all for your help in advance....more >>

Hi, I'm working with SQL SERVER 2000 (SP3). In Enterprise Manager, Replication, Subscriptions, the status is "never started" and the replication icon is the one wich indicates "agent is not running" for my pull subscriptions. But, all is running ok. I want to see the correct status informatio...more >>

I have set up a bi directional replication (Thanks George Li). The replication is working fine. But I am facing certain problems which I would like say giving an examle Server 1 Database: dbReplication Table: tblTesting Columns: CID (primary key, identity not for replication) ...more >>

Hi....this is my first time to this newsgroup, but have enjoyed working with Michael Kaplan in the Access Replication newsgroup for a while now. We're working on be setting up a merge replication scenario for our sales force, with SQL 2000 Desktop running on their machines PULLing the sou...more >>

If I have to restore my publisher database, how would I sync it up with the subscriber database? Example: I have established Merge Replication and I lose my publisher database. Mean while, my subscriber makes changes to data. My thoughts would be to restore my publisher database from backups...more >>

Hello - I'm relatively new to SQL Server, but am a Certified Teradata Master. The company I work for runs an online store (ASP, ASP.NET applications) on an SQL Cluster. The OS on the cluster is W2kAS. The SQL Server is SQL Server 2000 EE. (This is the production server) We want to...more >>

If I restore a publication database performing transactional replication onto another server, will the subscriber recognize the publication? How do I plan for this type of move? Anjelina...more >>

During the creation or reinit of a subscription, the tables involved in the publication are schema locked. Where can I find information about why this is needed and details of what a schema lock is. The BOL are very vague in this area. Thanks ...more >>

Hi, Can anybodybody point me to sites that provide good examples of setting up any type of replication. I would prefer examples that use a single database server. cheers martin. ...more >>

Hopefully someone can give me some insight or tell me what I am trying to do is crazy :) I have been tasked with getting several database hosts in sync. First off, let me give some back ground. We have 4 tiers of databases (Editor, Development, QA, Production). Editor is an offsite contr...more >>

On a Sql Server 2k system I get an error message "Insert Error: Column name or number of supplied values does not match table definition". I get this on a table that has 0 rows, and on another table. I am sure that the table definitions on the publisher and subscriber are the same. How do I ...more >>

Is there a way to schedule the services for SQL to stop and start automatically?? Brian...more >>

Is there a way to schedule the services for SQL to stop and start automatically?? Brian...more >>

I have more than 3 servers working under replication (server a -> server b -> server c...). currently my boss wants to setup an additional backup server for server a using logshipping. logshipping works fine, but the backup server can not restore replication settings after actived. can any...more >>

Dear All, I tried to replicate my database from one server to other server. Both servers are WIN 2000 and have SQL servers 2000 installed. I choosed pull replication and transactional replication. When I started synchroising the database, I've received an error message: Could not find sto...more >>

Has anyone ever seen this error, how can I get by this. My computer name is NOT "local". However, it keeps poping this up in SQL, and shows "local as the SQL Server Name. SQL Server replication does not support nickhames, such as "." or "(local)", as server names. Delete the SQL Ser...more >>

Merge between two DBs (heavy insert) replication monitor: The process is running and waiting for a response from one of the backend connections. Where I can configure the backend connection to speed up the process? It is too slow. Thanks Nathan ...more >>

Hi , Did anybody manually delete before records from one of this tables and if yes it was there any problem? Thank you Florica ...more >>

I'm trying to replicate a database from one SQL 7 server to another using the push subscription method but my full text indexes are not being replicated to the subscriber? I understand that full-text catalogues are stored separately from the tables and cannot be replicated but surely the indexes...more >>

Hi, I have disabled my replication on my server, but the rowguid column is still in my tables. Is there a way to remove erverything replication puts into the tables? Thanks, Jim...more >>

I am trying to synchronize data from a SQL7 workstation to a SQL7 laptop. I am constantly receiving the following error: "The process could not enumerate changes at the subscriber." Does anyone have an idea where I can begin troubleshooting this error? I tried the Knowledge Base, but the a...more >>

Our company needs to implement replication between two servers located at two different locations connected via a point to point T1. Our research seems to indicate we should use log shipping for replication and that we should have bought SQL 2000 Enterprise Edition, which we did not. My bo...more >>

I've read a lot of things on Google, Books Online, MSDN, other website, but I'm almost there. Let me tell you what I'm trying to do, what I've done, and is it even possible. |-------------------| | Repository Server | |-------------------| / | \ / ...more >>

We are planning to a move a large database to a new server. This database is setup as the publisher and performs transactional replication to a dss database. What will happen to the publication and subscription when this is performed? Will I will need to create a new publication and new ...more >>

Hi all, I am testing merge replication between servers running SQLServer 2000. I am worried about the status of the data following a network failure. Is it posiible for the publisher and the subscribers to remain unsynchronized? What happens when they start synchronizing again? thanks ...more >>

I have two machines running MSSQL Server 2000 (SP3), testing replication. When doing a Push Subscription to a Merge Publication, the snapshot is applied, and then I get the following error: The subscription to publication 'Merge_RecyclingDB' is invalid. (Source: Merge Replication ...more >>

I need to form the following scheme: Oracle: Publisher SQL: Distributor and Subscriber I know like forming dist. and susc. but, I don't know make the pub. in Oracle...more >>

Hello, i'm working in a transactional replication setup but i need to find a way to clear the transactions ready to be distributed, the log reader already put the transactions in distribution base, is there a way to clear this pending transactions to avoid the replication to the subscribers, the ...more >>

Regards and thanks in advance. Recently, while trying to restore a backup, a connection timeout prevented the db from being restored (no data/log files), but have an entry showing up in enterprise manager and being reported as 'loading/suspect'. I cannot delete the entry because it being 'used...more >>

When executing sp_removedbreplication, the following error is received: MSG 3701 cannot drop the table Savant.conflict_Savant_zone because it does not exist in the system catalog. I was able to locate it in sysobjects. Thanks for any ideas....more >>

I have OLTP and Reporting environment. I can't keep history data in OLTP, so I have to have nightly archive/cleanup job to delete older data, but I don't want to replicate those DELETE transactions over to Reporting. Meaning, I want to keep all the history data on reporting environment. ...more >>

I have several databases on my MS SQL servers that were created by the developers. There are many tables on them, whenever I tried to establish replication, it complains no unique key for the tables I wanted to replicate. Is it a must that all tables need to have unique keys/Primary key to...more >>

I'm running SQL Server 2000 SP2 transactional replication. Periodically replication fails due to primary key errors. On investigation I find that the offending transaction is attempting to insert a duplicate of a recently replicated row (identical data including the rowtimestamp, which is aut...more >>

Hello, I'm configuring my first replication process. When I finsih the Publisher configuration, in the Replication Monitor (the same server that publisher) appears the server with the database that I configured with a red cross produced by a LogReader that is in a Failed status with this last ac...more >>