I have publisher and distrubeter which is SQL 2000SP4 and subscriber SQL 2005 sp2. I am not able to set replecation from SQL 2000 to SQL 2005 can some one help Thanks ...more >>

Hi replication gurus, I have three questions here regarding replication parameters: 1. SubscriptionStreams: It seems I cannot put this parameter into a user created profile, so if I want to add/change this parameter for distribution agent, I can only do this by going the distributor agent JOB ...more >>

Hi I wonder if anyone out there know about a book on replication you can recomend? A book that is easy to read but with advanced things as well. thanks //Regina...more >>

I've been trying for the last few days to get replication up and running between two servers, and I keep getting these kinds of errors. The table in question has only three varchar columns, and on both source and destination they're Latin1_General_CI_AS. There are no BLOB type columns in the t...more >>

I've recently come accross this replication issue i've not had before, the replication is running in the following environment.... Machine A - Server 2000, SQL Server 2000 SP4, The Publisher Machine B - Server 2003, SQL Server 2005 SP2, The Subscriber, Pull Subscription The snapshot is pr...more >>

I am setting up SQL Server 2005 for merge replication with around 160 clients running SQL Server 2005 Express and set up for pull subscription. The data will be partitioned but the partitions will be overlapping. I am trying to keep as many tables as possible as download only. On a developmen...more >>

During a deploy I managed to break a subscription. Obviously the answer is to refresh the subscription with a snapshot. The problem I'm running into is that these subscriptions are all on a shared agent. So I'm getting this error message: 2007-08-30 23:10:10.947 Agent message code 21074. Th...more >>

Hi Issue with SQL replication: My SQL server has been set up in a system with a static IP/ domain name. A server alias has been created for the ip and soain name in client network utility. Case 1# My SQL server name is same as my Computer Name ("raj"): - I am able to configure the ...more >>

i have setup merge replication many many times, but I am receiving errors on this machine. It crahsed, and we had to restore the data, so now i am trying to setup merge again. WHen I use EM (SQL 2000 on Windows 2003 server), I receive at the configuring distributor step: Error 15110: the pr...more >>

I've configured replication alerts on SQL 2000 and enabled them. However, although some of the events have occurred and been written to the event log, all of my alerts still say (Never Occurred) under the "Last Occurred" column. Can someone tell me why they're not firing? Thank you. --Tiffan...more >>

Publisher: SQL Server 2005 SP2 Subscriber: SQLExpress SP2 Merge pull replication Merge process stopped uploading changes to the publisher. Downloading changes to subscriber works fine. When record inserted/updated, reference is saved into MSmerge_contents, generation incremented. Merge proc...more >>

Hi, I am having problems setting up database mirroring (SQL Server 2005). I made a backup of my database and transaction log, I restore this on my Mirror server. I established the end points and I set the partner on my mirror server, I then received the error "The remote copy of database "D...more >>

Hi I have a question about merge replication. We hav one server as master and 3 subscribers. In prodoktion we have noticed that the replikation takes time that we wish to reduce. one way to try to reduce the time is to drop two articles from the merge replication. When I was trying this on o...more >>

Hi all, I have configured a snapshot replication. The distributor is a different machine than the publisher. Both of then connect each other by using sa password. Now I changed the sa password at the publisher server and (of course) the distributor can't connect to de publisher to generate ...more >>

It seems that the real benefit of using a distributor is when there are multiple subscribers to a publication. If we only have one subscriber is there any benefit to using a distributor? ...more >>

I am trying to configure merge replication on a machine that crashed. we have reloaded everything and loaded SP4 for SQL 2000. When I try to configure the subscriber, I receive an error msdb.dbo.sp_add_jobstep_interval is not found. I looked in the msdb database and that SP is not there - why?? ...more >>

I have had an instance where certain rows have disappeared from the main server following a replication session. We are using Merge (pull) subscriptions using SQL2K standard as publisher and MSDE as the subscriber. The records that went messing are all in the tombstone with a reason of "...more >>

We changed the 'sa' password on the subscriber to the exact same password but then the transactional replication from the distributor to subscriber is throwing this error: Login failed for user 'sa'. (Source: MSSQLServer, Error number: 18456) We tried resetting the password under the distrib...more >>

Where might I begin debugging the following: When I update a row on the Updatable Subscription, I'm getting the following error: <start> No row was updated. The data in row 1 was not committed. Error Source: .Net SqlClient Data Provider Error Message: The RPC security information for t...more >>

Hi All, Our database running on SQL Server 2005 (with SP2) version and one large database have transactional replication setup on it. The daily loaded data around 80 million records. The log reader agent latency goes to 6 hours. I checked web site, it says use -MaxCmdsInTran, -SubscriptionStr...more >>

question: I need to setup a Data Warehousing/Archiving Database. Data needs to move from our production database over to this new database. There are a few large tables that we would want to purge old data on our production Database, this would be done on a monthly schedule. The purged data...more >>

I have a need to create an exact duplicate of a SQL database within the same domain. This duplicate copies must be 100% synchronized at all times and they both need to be updateable. This database is the back end for a commercial softwarre application for which we do not possess the source c...more >>

hi I went down the replic and then mirroring route and now since the goal posts have changed for my project yet again, im back to the drawing board (again) I have a requirement for users to be able to access either the production OR the mirror / replica / hot / whatever server without thet...more >>

Hi, Here is my scenario, any advice would be much appreciated; I have a main database, part of which will be updated manually through a web interface by approximatly 50 concurrent users, the other part will only be updated by a bulk import occuring every 6 months or so. The portion of the d...more >>

Hello All, If I want to replicate from a full SQL Server 2005 instance to say 500 clients running SQL Server CE would I need 500 client access licenses (CALS) or a processor license for the full server - assuming all clients could connect simultaneously? Thanks, Gerhard...more >>