Hi Freinds, SQL 2000 If I create a snapshot replication, when it start syncronizing, does it push all data again, or just the portion that is modified or added? Thanks, Patrick ...more >>

Hi Freinds, SQL2000 I want to replicate a database that has tables with different schemas. user1.invoice user2.invoice user2.invoice user1.invoice_detail user2.invoice_detail .. .. .. When t run the snapshot, itcreates the tables for dbo and causing problems. What are my options to...more >>

Hi, Does Log Reader Agent actually write any "Ready to Move" data into the Distribution database. If so, I am not able to find any tables that hold the "Ready" data. Any idea? Thanks Ed ...more >>

I'm looking for information on replication with a mainframe iAM database to SQL Server, whether that is something that might be established through the use of SQL or through a specific 3rd party product. Any help would be greatly appreciated!...more >>

All, I am testing a clustering solution on Windows 2003 Enterprise and SQL Server 2000 SP3a (Microsoft SQL Server 2000 - 8.00.760). Due to unavailability of hardware we got 1 pyhsical (node1) and 1 virtual machine (node2) as the 2 nodes of the cluster. SQL Server instance is the remote distrib...more >>

Hi, We have set up merge replication between a few boxes. I make changes on one box, replicate, and check the tables on the other box. The inserts are being replicated, and some updates. It appears that the updates made out of a stored proc are not being replicated. I can manually updat...more >>

Hello, I have a merge replication scenario which is using 3 seperate snapshot/sync processes one of which has an extremely large table. All of a sudden the weekly snapshot generation of the process with the extremely large table is failing stating that it has bulk copied 0 rows. Not much ...more >>

I saw Log Reader agent is working in Snapshot Replication Environment. is this ture or diffrent set up of replication i think we dont require Log reader agent for Snapshot Replication. please advice Thanks, John....more >>

Does anyone know how to monitor SQLServer replication through Delphi environment? Using MSSQL. ...more >>

We are planning on moving some SQL Server databases that are currenlty running Merge replication as the publisher and distributor. The existing server will eventually be scrapped and the new server will take over as the new Publisher/Distributor. The current server is replication to a subscr...more >>

HI, I'm getting this error on a merge subscription between SQL SERVER 2000 and SQL SERVER CE 2.0. Ocurrs 4 error: 1. A call to SQL Server reconciler failed. 29006 2. The process could not log conflict information. 3. {call [ap_cft_956C31C4D7234B324E83FF479D5444B7](?,?,?,?,?,?,?)} 4. Datetime...more >>

hi i moved one of my test database to another testing dep server. what ever the chnages happen in Publisher database, it need to sync subscriber database at a particular time. so i have choosen Snapshot Replication. i want only updatabale data should move to subsciber database on nightly basi...more >>

We have an application using MSDE that does not have connectivity with our main SQLServer DB, yet I want to be able to ftp changes (using MERGE) to the client and have MSDE apply the data. Is this even possible? I've been looking around for quite some time and have not seen an option for a ...more >>

Hello. I have the following situation: we have one database that contains vital date, but there isn’t replication between that database and our primary server. This is what I have tried: I created merge replication (pull) between these to databases. Everything went well, but the old data...more >>

Hello... Currently we have merge replication set up between SQL 2000 and mobile devices running SQL CE 2.0...and some with SQL Mobile. As part of the logic on the device, we have to set some properties for the SqlCeReplication object. Some of these we make dynamic, like the publicatio...more >>

Does Merge Replication take much more time than Snapshot Replication. I run Merge Replication from SQL Server enterprice manager and alway tell me timeout expire. Thanks ...more >>

Hi I have an inventory Table that is updated every 1 hr on our stage database. This then replicates down to our reporting server using tranactional replication . We have web pages that access the inventory table on our reporting server and when reporting from this, this is sometimes blank d...more >>

Hi, first let me explain the situation. I hav a database which contains more than 500 tables ... now we are setting up another server and the requirment is like i want to replicate the data of 5 tables with the new server. i dont want to replicate the entire database ... plz guide me for t...more >>

I have a client with approximately 30 laptops all running SQL Server 2000 (databse is about 13 gigabytes, this is _not_ MSDE). They have a legacy application written in VB 6.0. The decision has been made to change their replication model. Replication between a "central" SQL Server database an...more >>

Hi , I am trying to drop manually table (on the subscriber) that was part of merge publication before but got the below message. The publication was dropped using E.M and even when try to re-create merge publication and add this table it failed due to the fact that the it can not ...more >>

Hi All !!!! I clone sqlserver's files from one server(A) to another server(B), . On the (A) server there were transactional replication from server(A) to subscriber server(XX). There are ditributor and publiatio on same server(A). After cloning sql files to server(B) i got the distribution and...more >>

Dear Freinds, I am really in trouble and need your guidance. I was facing problem for the replicaiton on my subscriber i was getting error that the object is not present with some procedure starting with tswv_ to solve the same problme i refere to the question there was a method sugges...more >>

Hi, From what I understand, in Trans. Replication, the distrib. database holds the information sent from Log Reader Agent about what needs to be sent to subscriber. Once the info. are sent, data will be removed from distrib. db. Am I correct? I am not sure what are the role of distrb....more >>

Hi, I am using a job to take daily backup. BACKUP DATABASE databasenameTO DISK=N'path' WITH INIT,NOUNLOAD,NAME=N'name', NOSKIP,STATS=10,NOFORMAT and it was working fine. When I tried to restore the backup, I couldn't restore it, the backup was uncompleted(I know this only when i tried ...more >>

SQL Server Replication - How are Inserts / Updates / Deletes captured from the base SQL Server tables? I get the feeling that snapshot tables are used but how are changes determined and then distributed to queues? Is there a trigger placed on the rows? Can't seem to find this answer in the Ho...more >>

I have a SQL Server database up and running on my domain...I want to create a transactional replication between Informix 10 and SQL Server 2005. Can this be done with SQL Server 2005 replication developing?...more >>

Hi, I have an application that have a single publisher with 7 anonymous merge subscriber (SQL2000). Distributor is in my publication server. I have 7 publications (one db) - most of them synchronizing every half an hour or so. However, I have a publication that needs to be as up-to-date i...more >>

Hello to all: The customer is contractually obliged to provide transactional publication across a WAN. They have several database. One published database goes across the WAN to one subscriber database. This works for about 8 databases, all less than about 20 Gb. Their largest database ...more >>

I cannot get a pull subscription to work. I have created my publication to allow anynonomous. The client is a registered subscriber. On the subscriber I created the pull subscription always specifying the SQL server authentication and entering the login/password. I have enabled loggin, but I can...more >>

Dear Friends, I configures Log shipping for LSW database. Transaction log successfully taking. successfully copy Transaction log. successfully restore Transaction log in stand by server. SQL Server Agent Account running on domain User Account, having full administrative privilages. But i...more >>

What is the best practice for moving an existing subscription to a new = server? We have a new sql server that will replace the server where my = replicated database lives, so I would like to move the replicated = database to the new server & change the publication to point to the new = serve...more >>

May I get the general meaning of this message and what may I do to "clear" it? ...more >>

Is it possible in SQL Server to have replication happen immediately as changes are made. That is, a change is made on server A, and that change is automatically applied to server B, rather than the replication happening at set intervals? Thanks. ...more >>

What is the correct way to restore a backup of a published database onto a different server with no replication? Here's my situation. The production db (Sql 2k sp3a) is published using transactional replication and a remote distributor. I restored a full backup of this database onto a test...more >>

Hi. In a previous post I asked if there was anything that we could do to help the cleanup job run better. We then realized that we had over 12,000,000 records in MSreplcommands. We have been "reducing" the max retention parameter. It was sitting at 72 hours. We started reducing this para...more >>

I have a real sticky problem that I hope one of you bright SQL gods can help me with. We want to have 4 SQL 2000 servers, all located at different sites on different networks (totally different networks...meaning not the same company) .. Users will update their local distributed database and n...more >>