I have a very strange thing happening where the primary key field is getting changed when synchronizing with a subscriber. Background: -Using SQL 2k and merge replication -Testing with Publisher and Distributor on same server. -Setup only 1 subscriber to test. -Added a record into the Publi...more >>

Hi, Transactional log on the subscriber is growing so fast that is running of disk space. I can't truncate and shrink it. What can be done in this situation?...more >>

We are experiencing lost records in some FK tables and I don't know if it can be caused by synching failures. For example, we have a table named People that is created and then a 2nd table record is created with a FK (ApplicantInfo) that links to the PK on the People table. For some reason, ...more >>

Can the distributor be on another server that does not have SQL Server on it. Using SQL 2k merge replication. Thanks. David ...more >>

We have a couple of laptop subscribers that are timing out or they are stopping a synch before it finishes due to a long synch time. Is this damaging anything? We seem to be losing records or getting conflicts because of this. Thanks. p.s. Merge replication SQL 2k and MSDE. David ...more >>

One of our customers is having some of the subscriber laptops take over 1/2 hour to synch with the Publisher, even when the volume of changes is less than 50,000. I watched it once and it seemed to hang for 5 minutes on a table with only 50 changes to it. Any idea what I can do to try to spe...more >>

We have setup transactional replication with queued updating between two machines. both machines have the same sqlagent account with the same password. When inserting records on the Publishers ( e. on the table) then the data gets replicated fine and the subscriber gets updated with the insert...more >>

I generated snapshot for transactional replication. During bulk coping I have got the error for the distribution agent "Agent suspect. No responce during 10 min". What shall I do to continue the process? ...more >>

Hi , I have set up queued updating at local server. i have managed to create a customer and it got replicated over to the other site. However, when i tried to modify some details of the customer or even delete that customer. and when i start sychronize it shows that x commands has been d...more >>

Hello there, I'm experiencing a really weird problem: I have a SqlCE subscriber connecting via IIS to a SQL Server 2005 database. The database publisher/distributor and the web server are on different machines (IIS being in a DMZ) and I want to avoid the use of Kerberos delegation to share...more >>

We are having some data conflicts with some laptops that have "timed out" and not finishing a synch. Once they are successful, will these conflicts resolve themselves? For example one of the conflicts is due to a FK/PK problem because (I think) that one of the tables did not get synched and ...more >>

Ok, perhaps I'm a moron.. believe me, I'd be glad to admit it if I could just get this fixed. We're trying to merge replicate data via https, we have installed the CA certificate and can connect to the replisapi.dll through IE. I used the following script to generate the subscription: DECLA...more >>

Here I my setup: I have MS SQL Server 2000 running on two servers both named MYSERVER. These servers are both on different domains, DOMAIN1 and DOMAIN2. I set up Merge replication for TESTDB on DOMAIN1\MYSERVER I created TESTDB on DOMAIN2\MYSERVER After I set up the push subscription fr...more >>

Hi, I am going to establish transactional replication for a large production database database with manual synchronization. 1. I backup production database on Publisher 2. I restore database on Subscriber 3. I create publication with manual synchronization 4. I create stored procedures for r...more >>

I have a 100GB published database. This database uses a transactional replication. I have full, dif and transaction logs backups of the published database. Whaat do I need to do to restore this databse without doing a new snapshot? There are no backup of distribution or subscriber databses. Do...more >>

Hi, I'm Roby Eisenbraun Martins. I'm a C++,VB and C# developer. I need to work with an offline database. This database will have a table, just like the server, Where I need to copy a filtered group of data. The ideia is to keep my local table synchronized with the filtered gr...more >>

This should be an easy question. I just started reading about transactional replication and just wanted to make sure I understood the concept. If I were to employ this I would need 3 servers. The Publisher on 1 server, the distributor on another server and the subscriber on the 3 rd server. Is...more >>

I recently Upgraded both of my servers to SQL Server 2005 Standard. Upon trying to set up Merge replication between the 2, I get this error: For merge publications, the version of the Subscriber must not exceed the version of the Publisher. (New Subscription Wizard) They both have 2005 in...more >>

I can't figure out how to set immediate updating subscribers. In the instructions I have it shows that when creating a publication, once I've chosen the type of replication (transactional in my case), the next screen which is supposed to appear asks whether I want immediate or queud updating....more >>

I have a database that captures real time production data that I'm trying to keep lean 'n mean. We don't want our analysts querying this db all day. So, we've decided to have a second db that we will keep in sync with the lean 'n mean production db, and the analysts can query this until the c...more >>

Hello everyone, We have a bit of a problem with replication between two SQL servers belonging to different domains. Basically we have two active directory domains: DomA and DomB (neither of them is local domain). Each of then has a SQL Server 2000 Enterprise edition installed with SP3. ...more >>

I am wanting to implement log shipping on a new install of sql2005 standard. I searched the site but couldn't really find my answer. Is log shipping "built-in" to SQL 2005 Standard? Scott...more >>

Hi, How can i set the subcription retention period using MSDE? Thanks ...more >>

Need help here. We need to have two database servers in separate facilities kept up to date. With a disaster we start using the second one. SQL replication won't do it because not all tables have primary keys. Data mirror won't work for the same reason. Likewise Lakeview Tech. Anyone h...more >>

Hi, all We are preparing to have sql2005 failover cluster. I have no experience on it. My question is that 1.there is any complete step by step docs for sql2005 installation on win2003 cluster server? 2. there is any training class in new york that I could attend for 1 day or 2 just for sql...more >>

Hi all I would be very grateful for any suggestions as to how to deal with a problem in transactional replication. I am encountering the following error message: Msg 18773, Level 16, State 1, Procedure sp_replcmds, Line 1 Could not locate text information records for column 12 during comman...more >>

1st question: can this value be changed from 'false' to 'true' after a publication is up and running? 2nd question: can this be accomplished without re-initializing the subscribers? 3rd question: if #1 & #2 are true what steps must be done to do this? Note: I have already tried the...more >>

Howdy all... long time no talk. I have one way transactional, pull subsription replication. If I run: exec sp_addarticle @publication = N'APSPub1', @article = N'NoticeVerb', @source_owner = N'dbo', @source_object = N'NoticeVerb', @destination_table = N'NoticeVerb', @type = N'logbased', ...more >>

'************************************************************************ ' Visual Basic ActiveX Script '************************************************************************ Option Explicit Function Main() Dim objConnection Dim objRecordSet Dim strTotal Dim strPathtoTextFile DTS...more >>

We are trying to track down the source of some deleted records in a table that may have been deleted from subscribers. Is there any log or system table we can search to see where these deletes occurred? Thanks. p.s. We are on SQL 2k using merge replication. David Chase ...more >>

Hi All, On a server I configured publication of a database and push subcriptions successfully using Enterprise Manager. But later when I select the "Configure Publishing, Subsribers and Distribution" option again by either right clicking on Replication folder or Menu, I find Subscribers...more >>

Hi, I'm Roby Eisenbraun Martins. I'm a C++, VB and C# developer. I'm still trying to work with SQL Server 2005 and SQL Express 2005. I need to create a merge between this two databases. The SQL Express database will work as an offline database. I can create the subscr...more >>

Hello there On my live replication, I need, sometimes, to change schema of replicated tables. Because, as long as the table is replicated, i can't change the schema, I simple do: 1. Remove the article from the parent table 2. change the schema of the current table 3. add it again to the...more >>

How to differentiate between a replication trigger and a normal trigger using T-SQL?...more >>

Howzit, Anyone know how to change an identity column so that "Not for Replication" is switched on? In SQL 2000 i did this: UPDATE syscolumns SET colstat = colstat | 8 WHERE colstat & 1 > 0 AND c.colstat & 8 = 0 but SQL 2005 does not allow this at all. So far, no problems with the edit...more >>

Hi all, I've enabled transactional replication same error again, but this time i did with 'nosync initializations'. I took the last backup from branch and restore in the subscriber server. I've created custom stored procedures for insert, update and delete for each article and execute into ...more >>

I have 7 sites. Each site writes data to a table called Carc_A. I want to replicate all the site's data back to one central database into a table called Carc_A When I tried setting this up before I ended up with Site's 1 to 7 having all the other sites data put in their tables. How can I ...more >>

I have a merge publication (SQL 2k) and needed to add a column to a replicated table. I used the stored proc and settings below and it seemed to work fine. When I synched with a subscriber, it seemed to have applied the table modification first, then downloaded the updates that were on the ...more >>

I want to restore a full backup of one of our customers Publication databases (SQL 2k) to our test server. When I try it, all of the replication info is dropped, which is ok as I can just go through re-creating the publication. Is there a better way to accomplish this as I don't want to cr...more >>