I have SQL in a cluster with Log Shipping enabled to a remote DR server. Yesterday, I did my regular security updates following KB article Q174799. Now my log shipping job is out of synch and it looks like I need to re-create it. What would have caused this given the database was never of...more >>

When I access the Agent Properties of a pull subscription by clicking the Subscriptions folder in the left pane of EM on the subscribing server, right clicking the subscription, choosing properties, then clicking the Synchronization tab the Agent Properties and View Conflicts buttons are dis...more >>

Hi All, Where can i get any doc to configure republishing for merge replication topology on sql 2000. tq. ...more >>

Is Mirroring only on SQL SERVER 2005 Enterprise Version possible or also in the standard Version.(REDO Thread ??) Is the Service Pack 1 for SQL Server 2005 available. best regard F.E....more >>

I had installed SP-4 many times, but first time i am installing on the Server which are Publisher & Subcriber & i am using Transactional Replication. i need your help if there are any steps or process when you install SP-4 on Servers which are used for Replication.(Transactional) My subscribe...more >>

Hello, Does anyone know the stored procedure (if there is one) used to check the status of a pull subscriber. Not necessarily the status of if it's running or not rather I'm looking to query the publisher/distributer to see if the subscriber is marked for reinitialization. Right now I can s...more >>

We are planning to setup Production Database servers in the new location for disaster recovery. Following is my requirement.Please advise me. LogShip Setup from SF to Vegas Log Backups runs every 15 minutes Log Backup size 30GB/Day, 2GB/15mi...more >>

Merge replication, SQL 2000. We are getting conflicts when a laptop (subscriber) synchs with the network (publisher) that indicates records in a table were not inserted due to related records in another table were missing. The 2 tables are named People and ApplicantInfo. When a record is ...more >>

Guys, I am bascially new to sql and log shipping. I noticed when I added a table to my source database, the destination doesn't synchronize. Does it only synchronized transations only? For example, when I added a record in the table, it works fine. So what is the best practice if somebo...more >>

Greetings! I am planning simple trans replication on SQL 2000 of a few tables. The publisher and distributor are on same server and we are pushing to remote (but still on internal network) subscriber. There will be no partitioning of the replicated tables, the subscriber gets the whol...more >>

I am setting up log shipping of SharePoint databases from a two node active/passive cluster to a stand alone instance of SQL. Versions are SQL 2000 w/ SP 3a on Windows 2003 SP1. Questions: - When I setup log shipping and designate a shared folder, what is the best practice for the location...more >>

I am have an issue with a primary key conflict during merge replication. The first error is: The row was updated at 'HDC.Hospital' but could not be updated at 'TABLET2\VIA_MSDE.Hospital'. Violation of PRIMARY KEY constraint 'PK_TranLines'. Cannot insert duplicate key in object 'TranLines'....more >>

Where can I find a step by step instruction to check why I have 'Initializing SQL Server Reconciler has failed.' when I try to sync? Evan ...more >>

I need your help & suggestion to correct my approach/Option. couple of days back i ran in to Replication Error. So i dropped & re-created my Subscription with no-sync. after running Application Reports, reports were not accurate. so keep customer happy i decided this 2 options. i need your he...more >>

Hello, I'm closely examining the pattern http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpatterns/html/ArcDataReplication.asp I have a 'Composite Movement Set' and a situation similar to the 'Complex Data Movement for Reporting Purposes, Figure 4'. Specifically, N databa...more >>

----------------------------------------------------------------------- A poll associated with this post was created, to vote and see th results, please visit http://www.dbtalk.net/t29922 ----------------------------------------------------------------------- Question: WebSyn - Merge Repl...more >>

I am running into a problem between two SQL 2005 boxes. I've created a new publication and enabled all the indexing on it to transfer. I've created a subscription, with creation of a new DB. None of the indexs are coming over nor is the full text catalog being built. Even if I enable it, ...more >>

Hello, we have 2 mssql 2000 machines. We use a push transaction-replication for a database. Everything worked fine until a machine was not reachable for a few hours. Now the publishing machine deleted the subscriber. No data has been replicated since these day. Can you please tell me in ...more >>

Good Morning Everyone, First the formalities... System Information: SQL 2000 - 8.00.760 - SP3, Enterprise Edition Cluster Environment Running Continuous Merge replication, with one subscriber. 24*7 web application Database Size Currently: 6 Gig (and growing) Now the issue: ...more >>

I'm really desperated when using Merge Replication between SQL Server 2005 and SQL Mobile 2005. The problem is related to filtering rows. I've got a table with a uniqueidentifier primary key field and another field which type is nvarchar(20). Row filtering with the nvarchar field works perfect...more >>

hi please bear with me as i'm new to this. i would like your advice in my attemp at replication have 2 (physical) servers (not a cluster) and have 2 instances of sql server running, 1 on each. i have to use replication so that if one goes down, the other is up and running with current ...more >>

Hi all, I've been trying to drop some tables (articles) from a Merge Publication. I have used the sp_dropmergesubscription to drop the subcriptions, and then sp_dropmergearticle to drop the actual article. sp_dropmergesubscription is running without problems, and no errors are being raised,...more >>

Dear all, let me introduce my self, I'm Joule from Jakarta this is my first time joining SQL server project. here's my problem i have two databases in separate server, one database use for security system and one for employee database. right now we have manually system which is mean i...more >>

Hi, I'm new to this Replication procedure. The replication Agent is set to run every hour. I would like to be able to have Replication on demand so that users can update their laptops before they go out in the field. Is that possible? Thanks, John ...more >>

OK I know why I have this error. My problem is how to go around it. I have this issue: Day 1: Device replicates and gets a table with client information filtered for the day 1 appointments (only ONLY the clients for this day) During the day the user edit the client information ...more >>

We have multiple SQL Server 2K DB servers which are geographically distributed and are expected to have same data at particular instance of time for ensuring same result for same set of inputs. For this set up – data consistency at all distributed DB servers, we are replicating the DB serve...more >>

Hi, I am trying to setup merge replication. I have selected some tables to be filtered. The snapshot agent was returning the following error: Message: In order to use partition_options of 2 (non overlapping partitions with multiple subscriptions per partition) or 3 (non overlapping partiti...more >>

Is Ok to clean msmerg_genhistory at publisher and not subscriber? We have a lot of subscribers merge replicating their data to a central server (The PUBLISHER). We are ok with having the retention period equal to 14 days. Thus, cleaning the merge contents, tombstone, and genhistory tables wit...more >>

I have been looking for information on how to view the details of what happened in a mege sync. When you click on subscriptions in enterprize manager the subscription will say something like "Merged 4000 data changes(1000 inserts, 3000 updates, 0 deletes, 0 resolved conflicts)" I would like...more >>

Getting Error message " Violation of primary key........................" on Subscriber. i don't want to add -skiperrors parameters. can i drop the Database & then Drop &re-create Sunscriptions. please advice or give me the best options. your help is appreciated....more >>

Hello, How can i remove a table from a replication ????? I can not unmark it in articles' list. Thanks, Mathew...more >>

I've setup replication for one of our databases. We have 3 agents. Snapshot, Log Reader and the Push agent. Log Reader and the Push agent work fine and run on schedule. The Snapshot agent has been giving me trouble for a month now. Using enterprise manager, I go into the snapshot agents pro...more >>

I using merge replication over a GPRS/3G connection how can check if the device is connected to GPRS/3G and if not create the connection? It's a C#.Net(2005) windows mobile application. Thanks ...more >>

Hello, I seem to be missing some config and/or concepts somewhere and would appreciate some help. I'm using transactional replication and the publications allow immediate and queued updating on the subscription. When I created the Push subscription, I selected the option "Immediate updat...more >>

Hello all, We have 2 database setup for merge replication for the last few years. I want to add a primary key to one of the tables. can i add it from the table designer in SQL Enterprise Manager? Or do i have to follow another procedure? thanks in advance regards Ishan...more >>

hello all, We have a table that has been setup for merge replication and has been in production for the last few years. I want to add a primary key to a table. is it safe to do so? and can i just got the table design in SQL Enteprise manager and add the primary key, or do i have to fol...more >>

Hi How to delete a push subscription at subscriber? The publisher server has a problem and no longer operational but at subscriber, a subscription still shows in synchronization in progress. Many thanks in advance ...more >>

I try do replication with vb. I check the sample code:http://msdn.microsoft.com/library/en-us/replprog/rp_replsamp_7yr2.asp If need to run instsamp.sql on SQL Query Analyzer to creates pull and push subscriptions and to start snapshot agency at SQL Server Enterprise Manager. how to start ...more >>

I have a publisher that was published to a remote distributor with push snapshot publications. Before I got here the publisher was removed from the network and rebuilt for another project. Now I can't delete the subscription at the remote distributor or at the subscriber because it wants to ...more >>

First let me apologize for the long post: The main publisher has eight subscribers, five of the subscribers are republishing subscriptions that are located in five other cities and each of the republishing subscription has at least one subscriber. We purge merge replication Meta data on ...more >>

How to drop & re-create subscription in Transaction Replication....more >>

I have a situation very much like the BOL example: Three servers in different parts of the world (Chicago, New York, and Bermuda). User groups in each location that update their home servers; and a need to replicate all updates to all three servers. As I read the BOL, I should use peer-to-peer m...more >>

I am getting following error, even though my subscriptions property is set to 336 hours & log reader agent is working fine. "The subscription has been marked inactive and must be reinitialized at the Publisher Error 21074". any help will be appreciated....more >>

I have a publication w/2 subscribers where I configured identity range mgmt on a table as follows: Range size @ publisher: 10000 Range size @ subscriber: 10000 new range %: 80 I used 10000, as I expect quite a few records to be added at possibly the publisher, but definitely the s...more >>

I have vendor application replication set up on Windows 2000 Advanced Server with SQL Server 2000 database. I received the error listed below several times during replication. Please help me resolve this replication error listed below. Thank You, dis-rpl Operating System Error Nu...more >>

Hi, I have a table called inventory_changes that needs to be merge replicated between server A and server B. There are triggers on each table that fire whenever a record gets replicated over. My problem is that I need the records to be replicated over in a certain order. For example,...more >>

Hi, I have implemented Merge Replication between 2 sql server 2000 instances, Imagine on ServerA am performing 1 column additon with default values to Table EMP and on the ServerB am adding 10rows to EMP Table. I want to control the synhronization in such a way that First SERVERB chang...more >>

Hi, REPOSTED (hopefully with proper nospam alias - apologies for duplication) I am following (roughly) the article Step by Step: Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005 and can't get past generating the subscription from the mobile database to t...more >>