Currently, we have peer-to-peer replication on two servers (server1 and server2). I added a few columns using sp_repladdcolumn stored procedure. Rows inserted at Server1 are replicated to Server2 without problems, and rows inserted Server2 can not be replicated to Server1 because of the err...more >>

Good afternoon, We have a full SQL server that has been running for many years now, we are getting ready to add a new SQL server and would like to be able to replicate the information from the old one to the new one. And then use the old one as a warm-backup I know there are 3 types of rep...more >>

Hello, I've got merge replication between 2 databases on the same server (MS SQL 2005 Std), every session ends with message: The merge process is retrying a failed operation made to article 'CLIENT' - Reason: 'String or binary data would be truncated.' Conflict viewer shows one row, rows seems ...more >>

Dear all, I am trying to set up a replication SQL server between 2 work office connected over private lan. Both office use SQL server 2005. Replication internal to each office works fine but when I try to setup replication between connection to server fails. After creating what to publish...more >>

I have a SQL Server 2005 database publishing a Merge Replication to about 10 tablets running the latest version of SQL Server Compact Edition. We have been using merge replication this way for about 10 months now without a problem. I recently redesigned the merge replication (took out some e...more >>

Hi, We have setup merge replication between 8 sites. 1 publisher and 7 subscribers, 6 subscribers are on different sites. All of the servers are windows 2003 R2 running SQL 2005. Right now none of the subscribers are getting data. When I launch replication monitor i see following message...more >>

Hi All, I am currently trying to mirror in high availability mode using a witness. i need to run an exe when any failover occurs. In the current scenario i need to know which server is the principal and the mirror and at the time of failover run that exe. since the principal can shut down and i...more >>

replication between to sql 2005 servers the publication type is snapshot and the subscriber type is transactional I have a problem with fast growing log files on the subscription database the data in the db is 48mb but the log file is 60 gb this is becomming a problem i urgently need to kno...more >>

I have a live system that uses merge replication. We are upgrading the system by setting up a whole new set of servers. When we go live on the new servers, I would like to copy into the new server database, any changes that have been made to the old databases. Unfortunately, replication add...more >>

Hi, I have a main database server running sql server 2000 with sp4. I have a a subscriber running sqlexpress 2005 server. I use transactionnal replication with updates autorise on the subscriber. My configuration seems correct as i can modify my tables content with INSERT command and found...more >>

I have a mirrored database with transactional replication publishing to 2 databases on different servers. The amount of data written to the principal is fairly low. The requirement is that at least one of the subscribers must be available at all times with a latency of no greater than five m...more >>

I've just been hired at a new job and the first project has to do with Merge replication with 150+ remote systems that publish to a local server (all SQL Server 2000). I've been reading in BOL and I'm confused. I know about log shipping, I know about clustering, but I don't understand how m...more >>

Greetings! We are replicating a table (many of them actually, but one in particular) which is about 10 GB...660K rows including some text columns. We needed to change the properties of one column and did not want to pay the penalty of reinitializing the subscription, so I added a temp colu...more >>

Dear all, I am building a n tiers application which is based on SQL server 2005 and ..NEt 3.0. I have a buisness logic layer which send information to the database layer to store certain type of data to SQL. Then at a specific client application event, like a simple buton clik event, I ...more >>

Greetings, I am looking for a tool that i can use to replicate oracle tables into Sql 2005 database. Or if i can pull the data out of oracle using a sql tool that would be perfect. The database tables are only 2GB or so. Can someone share some insight on whether this is feasible or not. ...more >>

Are index reorgs replicated? Currently we have index reorg tasks on both our transactional and reporting server and I was wondering if reorging or rebuilding the indexes on the reporting box every night was redundant. SQL 2005, one way transactional replication. Thanks in advance....more >>

Hi! I have one SQL 2005 SP2 Server in Paris and another one in Germany. The locations are connected via VPN. The ping-time is less than 25ms, with a bandwith of 2 MBit. The database I want to replicate has 4 tables. Two of the tables replicate without any errors, but the others one only ...more >>

I had stopped the synchronizing between the distributor and the 2 subscribers. I then did a bunch of deletes and inserts on the same table on the distributor. Now, when I start synchronizing again I receive: The merge process is retrying a failed operation made to article 'ICLocation' - Reason...more >>

Greetings, I'm looking for a document that does a really good comparison of merge replication, peer-to-peer transactional replication, and transactional replication with updating subscribers. Does anyone know of a site or document with such a comparison? I would especially be interested in ...more >>