We have a replicated environment with hundreds of subscribers (SQL2000 SP3a). Our server (EMOCADB..MDS) subscribes to a 'LoanProduct' subscription which publishes 'LoanProducts' and 'UserData' to a dozen sub databases on the same server. These sub databases then publish 'LoanProducts' and ...more >>

Hi , I would like to know what is the base approach for FK for tables out of the publication. I have several situations that I would like to add FK from tables out of publication ( tables that do not replicate at all – historical tables or replicate by different publication) to a...more >>

Hi, I have a few offices accross the country running MSDE and my HQ SQL 2000. I need to port the data nightly to the HQ. Should I consider Replication? Whatever is done on the MSDE at the offices are not needed after copied to the HQ. I was thinking of creating an app (running at all offices)...more >>

Hi All, Sorry if this has been asked before... I've installed MSDE to act as a merge subscriber, started the Server service to get it installed, then disaled the service. One way replication appears to work fine - is there any reason I can't leave the service disabled (may need to use a bidi...more >>

Hello. I'm trying unsuccesfully to replicate thru computers in a VPN. What's my CSI? ;) I have multiple computers all over the country. All of them with no real IPs. Only one of them has real ip. I have Kerio Router Firewall with VPN server. It works fine. everybody can connect from each ci...more >>

I have set up Mege replication where a publishing subscriber subscribes to a central publisher. The publishing subscriber publishes to other regional subscribers. All Subscriptions are set up as pull subscriptions using dynamic snapshots. The problem however is that when the associated appl...more >>

I am doing testing on a database between a SQL Server and a laptop usingmerge replication. I can see that each system is missing a record in each system. When i run the validation process the system identifies that the table are not in sync. Regardless of the resynchronization method I use th...more >>

OK. We have this 1 publisher db that is pushing out to two separate subscribers (one is transactional the other is snapshot). In the distribution db the publisher_database_id is going to be the same. We monitor this transaction count by publisher id with the following ( Select count(1) ...more >>

Hi, I'm trying to use the DTS wizard to subscribe to tables located in an OMNIS datafile. I have the ODBC drivers installed (manu stamp: raining data), but I constanty get a "Exception_Access_Violation" error. I'm newish to SQL server and am not quite sure where to start in order to resolv...more >>

Is it possible for a sqlce database to subscribe to 2 publications publish from the same server database? I have the sqlce sdf file created from synchronize with the 1st publication with the "AddOption.CreateDatabase". Then later i created a 2nd publication from the same database in the server ...more >>

I have set up an Updateable Subscriber replication between databases A and B. This creates and uses the MSreplication_queue system table in the destination (B) database. I have lot of other tables being replicated from A to B, all standard Transactional replication. e.g. Table C is replicat...more >>

We're trying to create a replication scheme for a simple data warehouse for reporting. I've been looking at the Books Online for SQL Server 2005 and feel like I've been going around in circles. Here's a simple case that we are having problems with. The prototype for the reporting was done ...more >>

We have a database that we would like to replicate to another server. Am i correct to asume that the database that is updated would be the publisher and that the subscriber database would be the replicated copy? ...more >>

I have a 70 GB merge-replicated production database on which I need to perform some maintenance. This maintenance will require the removal of my subscription. I am trying to minimize downtime, obviously, and wonder about the ramifications, if any, of setting up a no-sync subscription after m...more >>

Hi, I need to configure Peer-to-Peer Replication for a database between two SQL 2005 hosts. However I have few newbie questions on doing so: 1. Is it required to have both the SQL servers part of a domain or can this be achieved with them being in Workgroup mode? 2. I came across this art...more >>

I'm using Merge replication on a table with an autoidentity field. All users are entering data at the publisher (no records are ever deleted), and at the subscribers the data is read-only. I'm having a problem with records being deleted at the publisher. I'm assuming it has to do with a subsc...more >>

I'm not certain if synch over the https is possible for transactional replication? I did see the setup for merge, but there is no mention of transactional. Now, is it possible or not? If not, why not? Second, initialization (access to snapshot) over https? Possible or not? MC ...more >>

Hello everyone. We have a bit of a problem with Windows Synchronisation Manager. Basically, we have two domain servers (not the same domain) that have a db on a SQL 2000 SP3a server. Those servers have a merge replication and everything works as it should until we set the Syncronisation Ma...more >>

Hello all! Did anyone successfuly created transactional replication between 2005 and 2000 SQL? Any problems, suggesstions? Thank you and kind regards, Dejan ...more >>

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 >>