Hi I am getting a timeout expired error on a transactional replication distribution agent. how do I go about figuring out what is wrong. I can select from the subscriber while in the publisher database, so does that mean the connection is OK. help thanks al...more >>

Okay I posted this yesterday I believe: “Let's say TableA on a 2000 ServerA.DatabaseA has an identity key and I want to transactionally replicate that TableA to a ServerB.DatabaseA (that is also 2000). But here's the catch: in the case of a significant outage on ServerA I want to be abl...more >>

We currently have a SQL2000 replication in place and we're considering moving one of the servers to SQL2005 x64. is 2000/2005 replication interoperable?. is the x64 2005 different in handling replication or is it interoperable with 32bit versions?(be it 2005 x64 to 2005 32b or 2000 32b) tha...more >>

I create the subscription table manually using the IDENTITY property and the NOT FOR REPLICATION option. I set the 'name conflicts article' property to 'keep the existing table unchanged' (Actually they are blank tables no any records in the tables). The question is after data are transfer...more >>

Can I use DISTRIB.EXE or REPLMERG.EXE to force SQL Express to synchronize a Pull Subscription on the SQL Express machine to the publisher (SQL Server)? ...more >>

I am currently trying to implement a replication strategy between n-many SQL Server 2000 databases, located on our hosting companies machine, and our reporting/datawarehouse server, located here in the office. So, I have 2 versions of SQL, Connection over the internet and 2 different domains ...more >>

Hello everybody, I cannot set my server as a distributor. It keeps telling me "SQL Server Agent on 'My Server Name ' currently uses the system account, Which causes replication between servers to fail. In the following dialog box specify another account for the Service startup account". I u...more >>

We have a SQL2000 Publisher, and SQL2005 server doing Distribution and Subscription. We're using transactional replication with push subscription. We've had this running reliably for 2 weeks with one publication with 21 articles. The database is a Great Plains DB for our UK office. We cre...more >>

Hey guys. I went to the Agent history for the distribution agent and it tells me 'A total of 1 transaction(s) with 8 command(s) were delivered.' Can someone tell me how I can check what was exactly done at this transaction? I need to know this because I just want to see wut it updated. Th...more >>

Hi all, my application (with sql server 2000) used transactional replication with several publishers and one subscriber. Because the subscriber could have its own data, when creating subscription I chose the "The subscriber has already schema and data" option, skipping initial snaphot from be...more >>

Hey. I've a few transactional publications. It fails with this error. When I looked at the command, it's trying to insert a null in identity column. Why does it do that? As of now, I've commented the update for the identity column in the sp_msupd_logdevicebeacon. But now, if somebody tries to ...more >>

I have a situation where I have SQL Server 2005 as my Publisher/Distributor and I have it setup to run Push Merge Replication. The subscriber is an instance of SQL Server Express. Obviously SQL Server Express doesn't have the means to force synchronization. I do have it setup at the moment ...more >>

Hello, SQL Server verison on Publisher: 8.00.970 SQL Server verison on Subscriber: 8.00.970 An update proc containing two statements was issued on the subscriber. The queue reader reports ODBC Error: Invalid cursor state. I do not believe that Q831997 Applies here, because the symptoms p...more >>

Hi all, got this error and well want some advice really. Cheers The process could not enumerate changes at the 'Subscriber'. (Source: Merge Replication Provider (Agent); Error number: -2147200999) --------------------------------------------------------------------------------------------------...more >>

Let's say TableA on a 2000 ServerA.DatabaseA has an identity key and I want to transactionally replicate that TableA to a ServerB.DatabaseA (that is also 2000). But here's the catch: in the case of a significant outage on ServerA I want to be able to repoint the web to ServerB.DatabaseA and ...more >>

Hi I have transactional replication on my server. If I need to restart the Agent or Sql Server is there anything I should be aware of or is there a set way to restart sql server or the agent. If I restart Sql Server while a transaction is going on will there be any corruption or will Sql Serve...more >>

Hi, We have about 50 databases (SQL Server 2000, SP3) which are merge replicated. We merge replicate about 100 odd tables in each of these database. We need to add couple of columns in one of our major transaction table where most insert/updates are being done. This table presently on averag...more >>

Is it possible to use multiple publishers- central subscriber topology in occasionally connected envinroment when publishers are connecting to internet using dial-up lines (they dont have static IP numbers)? glondi ...more >>

I'm starting down the road of considering merge replication in SQL Server 2005 (via IIS/HTTPS) (as opposed to writing my own synchronization code and communicating via Web Services). The more I look into it, I'm feeling more comfortable with it. Does anybody have any experience to share (good...more >>

When a subscriber has exceeded the retention period since the last sync, I've heard that it can upload it's changes to the publishser then reinitialize the subscription. How is this upload handled? Is this a manual process? Or is this case specifically handled by merge replication? Thank...more >>

I'm wondering how well merge replication scales to a large number of subscribers. Where is the state of the merge sync relationship between the publisher and subscriber stored? Is it in the subscriber database, distributor database, or in the publisher database? Thanks, Troy ...more >>

Once a merge relationship is established, what happens when either the publisher restores a previous backup, or the subscriber restores a previous backup? How is this handled? Will the latest data will be restored from the database that didn't crash? --Troy ...more >>

Hi all, We have a scenario here, based on which we have to decide on the type of replication to be designed. Each branch has a databse and in Head Office , there is a central server. Replication has to be done for disaster recovery, high availibility and central reporting. The requirements...more >>

I would like to achieve horizontal partitioning using merge replication. Several distributed sites will modify distinct sets of data. I want to consolidate data from different locations to central sever. Furthermore I am trying to adopt my client application to distributed database scenario,...more >>

Hi guys - I have been able to successfully create pull merge subscriptions in SQLDMO. Now I am trying to do anonymous subscriptions and I am having a little difficulty. I made sure to allow anonymous subscriptions at the publication. I created an object of type MergePullSubscription...more >>

I read the instructions on how to setup Windows Synchronization in order to "force" update from the SQL Express side in a replication scenerio. The problem is that I don't see SQL Server in my options of snchroization items...how do I add it? Is it possible to script this to synchronize from...more >>

I'm a newbie, so please forgive me if I posted this in the wrong group. I am comparing and contrasting replication vs mirroring in SQL Server 2005. I'm mainly looking for information on latency and performance differences, but any other info you have would be good too. I'd greatly appreciate i...more >>

I installed SQL Express on an instance of Microsoft Virtual Server. I haven't been able to connect to it from SQL Server which is running on the same network, but on our real server. Now I have been able to successfully able to connect to the real SQL Server from the Express but it doesn't...more >>

Is it possible to create a publication entirely from within my application? If so, are there some samples or documentation anyone can point me to? Thanks in advance, Terry ...more >>

We are going to be implementing merge replication between a main instance of SQL Server 2005 and potentially a hundred or so instances of SQL Express subscribers. Our business model is such that the SQL Express users will not be online all the time and when they are the merge replication wi...more >>

When adding an article I have checked the checkbox to show unpublished articles and then selected the required the tables. After this, I have run the snapshot agent for this publication. The 2 tables I added contained no data yet the snapshot started the coping of rows of other tables in...more >>

Dear all, I am going to set up a snapshot replicate. it will run nightly. The size of DB is around 2GB, does anyone know how long will it take to completed the snapshot replication. Is there any way of estimate the duration? Doesn't have to be very accurate, a rough figure will do. Thanks,...more >>

I am reasonably new to replication and am looking at applying it to the following scenario: Several distributed sites/servers which modify distinct sets of data - the database structure is the same at each site just the data will be different Central site which requires a readonly integrated...more >>

Hi Guys I am running SQL2000 I have set up Transactional Replication with a push subscription. My 2 servers are not in the same domain but can see eachother. Server 1 is Distributor as well as publisher. All insert, delete & updates made on this side replicates fine to server 2, however a...more >>

I am having a weird Web Sync Issue, that only started happening when using the RTM version of SQL 2005. Topology: SQL 2005 Pro publication with multiple SQL Express Subscribers synchronizing over Web Sync. Issue: On the client sometimes we get the error <<URL cannot be found>> indicating...more >>

Hi, I need to configure this scenario Part 1: Transactional publication configured in database A, the subscriber is database B. Part II: Configure a transactional publication in database B and send it to database C and D. I already configure the part 1 of the scenario. But when i try to ...more >>

We have a domain, say OUR_DOMAIN. Within this I replication running happily for several months from MYSQLSERVER . We now have another "trusted" domain at a co-location, OTHERDOMAIN. To see a machine from the other I need to use MYSQLSERVER.OUR_DOMAIN. However, when I set up a pull replicati...more >>

Hi everybody, I'm trying to remove a rowfilter (and 'JOINS') from one of my publication. When I first tried this on a testdatabase everything seemed to work. But it's not working on the productiondatabase. I always receive this message: Cannot drop filter 'Table1_Table2' from publication '...more >>

Hi , I would like to check if the modified date of the log file be changed only if there's not enough allocated disk space for the txn log and SQL needs to expand it ? This is because i have set a full recovery and doing full database & txn log backup every nite since 2 days ago and it...more >>

Is it possible to implemet following scenario using merge replication? 1. many remote sites gets global data from central server (like products info) 2. each of the remote site sends data collected at this site to central server ( for the conslidation purpouse and furhther data analysis a...more >>

HI , I found that the replication keeps failing and have logged the replication - -> scalaDB_MLD (not the Snapshot or logreader agent of that publication) and got the followings details : +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Adding alert to ms...more >>

Hi, hoping for some possible help or insight... We moved our database over to a much higher end server and now during our continuous replication cycle we seem to get pauses for as upto to 6 minutes at times then everything starts going through again. The subscriber and publisher are both i...more >>

Hello! I'm doing replication over non-trusted domains. I'm using FTP server to do that. I've also read Paul's articel about replication over non - trusted domains. I'm using snapshot and merge replication. Snapshot replication works OK, without any problems, but MERGE replication gives me ...more >>

We have number of SQL servers like Server1, Server2… deployed in different cities There will be one Main Server which gets updated/sync with the all the city servers We are planning to use SQL Replication technology or is there any other method to achieve this. We need your suggestion i...more >>

Hi , I am Srikanth from India. I have a problem while doing Merge Replication. After I implemented Merge Replication with PUSH publication im getting this error i.e., the merge process could not retrieve article information. I would really appreciate your help on the same. Thanks and...more >>

Is there naybody whu can help me to chek if reak connection is available between two sql server in large distance....more >>

Hi, I have got a problem after performing update of a large table which participates in transactional replication. Log reader and distribution agent are running but transactions keep gathering in distribution database (checked with select * from MSdistribution_status and sp_browsereplcmd). A...more >>

I have number of SQL servers like Server1, Server2… deployed in different cities There will be one Main Server which gets updated/sync with the all the city servers I'm planning to use SQL Replication technology. Is there any other method to achieve this. Please guide me. Thanks...more >>

Hi All, I have set up MERGE Replication I have couple of tables which have id as PK on table A and table B has id as FK. My problem is everything goes fine when i insert data in table A and B. but when MERGE agent runs it tries to insert data in table B first instead on table A. This gi...more >>

Hello I have a merge replication and I get the following error: The same row was updated at 'publisher.repl_name' and deleted at 'subscriber.Repl_name'. The resolver chose the update as the winner. The thing is there is no way if a record is being deleted in one server can be updated in an...more >>