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

Hi gurus: I have two questions: 1. If in 2nd step (Run Agent) of the distributor job, there is a parm, say HistoryVerboseLevel 3, while I apply to the distributor a user-defined agent proifle, which defines HistoryVerboseLevel 1, then what is the real value of the distributor regarding this ...more >>

How can I find the snapshot folder in SQL 2000, where would I look or if there are sp to return the location. Thanks ...more >>

Hello there I got an error when i run restore job: Database 'some database' is not in Norecovery\standby mode. what it that means? should i set it on database or in entire server? ...more >>

Hello there I have two databases with the same name at diffrent servers Server1.DbTest, Server2.DBTest I'm trying set log shipping between them so every update uccur in server1 will be don when the log ship occur. When i set with restore at the Server2 it gave me an error that he can't ...more >>

Hi gurus, If I want to switch the distributor agent profile, for example, from the system default profile to a new user-defined profile, I can do this from Replication Monitor by Expanding a specific publication and then under "All subscriptions" tab, right-click the subscription and select a...more >>

One of our customers had their publisher machine crash (harddrives went down). This is running merge replicaton. The subscribers have continued operating today. Their network person "backed up the database". As of right now, I don't know exactly what was backed up and how. Can someone poin...more >>

Hi, In order for merge replication to be setup I have created a SQL login on both the publisher and subscriber and granted it System admin, Process admin and Bulk Insert admin based on an article I read. Question is it necessary to grant these server roles at the subscriber and publishe...more >>

Hi, I have a setup a merge replication which is set to run continuously. At the subscriber side I am seeing the tables updated every minute or so. Is it possible increase the frequency of the replication? SQL Server 2005 Standard Thanks Aidan ...more >>

I have a main database that I need to distribute a copy of to another server for use by anotherb department to relieve load on the database server. Bothg need to be except replicas at all times. The database is currently hosted on a SQL Server 2005 Standard edition 64Bit database server. ...more >>

I am in SSMS and have set-up replication (I think). I have connected Server A and Server B in SSMS via SSMS Object Explorer. Server B is at another location and is connect via VPN I believe. Server A has the database I want to replicate somewhere else. I have setup Server A to be Distribu...more >>

Hi , We are facing trouble while setting up transactional push replication between SQL 2000 and SQL 2005. Publisher--SQL 2000 Distributir and Subscriber--SQL 2005 on same machine. We are getting below error while running the Snapshot agent and while expanding the publication from distr...more >>

Hello folks, I am trying to set up replication between a central office and multiple sites. This will be merge repl, since either central or satellites can be modified. However, one issue I ran into is setting up subscribers. I don't always have the option of starting with a publisher's snap...more >>

I have a Database at Location A that I want to Replicate to Location B once a day at the end of the day. Location B is really just for information purposes only EXCEPT 1 table which gets updated during the day. I was thinking I could export the ne data daily out and import it into A and th...more >>

I noticed this behavior in SQL2000 transactional repl. Updates may get replicated as deletes, then inserts. Is this still the case in SQL2005 trans repl? We would like to control deletes at the publisher, but not replicate those deletes to the subscriber. This will be a problem w/ updat...more >>

Hi all, I'm fairly new to SQL replication and I've been trying to setup a 'central subscriber' topology using transaction replication. First publisher went smoothly... second publisher, snapshot worked smoothly but now is coming up with a distribution agent error: The process could not ...more >>

Hello there For a knowlage i have i can't install sql server on windows NLB clustering. IF that so i have some idea how to improve performance using replication: create 3 or more subscibers of my database for pooling data. Create "Manual" technology that use more then one server for gettin...more >>

Can someone walk me through the simplest way to setup replication between 2 sql2000 servers? I've never done it before and can't seem to get it to work. ...more >>

I am trying to consolidate replication - I have several dozen publications that each go to anywhere from 1-20 subscribers. Performance is not where I want it, and it appears to be tied to the push subscriptions we have on the main machine. We have 3 options: move to pull subscriptions, make a s...more >>

Hi We are running a replication on SQL 2005 Win 2K machine. We have modified Store Procedures used by replication to block some columns getting replicated under certain scenrios The problem occures when these column contain '#' char. The replication stopd working giving us error Proced...more >>

SQL Server 2000: For Bidirectional Transactional Replication between only 2 servers, should a distribution database exist on only one server or on both servers? Thanks ...more >>

Hi, When I try to start the snapshot agent for a transactional publication it is hanging my database machine and makes it totally non-responsive until I have to switch it off manually. Just now this happened and I restarted the machine, tried to start the agent again and it became non-respon...more >>

Hi everybody, I want to make a replication between two new SQL Server 2005 SP2 Servers. Right now I'm doing it inside of my network. When i use the wizard y try to set the publisher and the subscriber throw the IP instead of the Server Name. But I can't. This is the error that I always get:...more >>

I have this error: The row was inserted at 'DISTRIBUTION.db_main' but could not be inserted at 'subscriber.db_test'. Could not find stored procedure 'bp_ins_8284C429C5514F08046769C0F2D24607'. How can I solve this problem? Thanks. ...more >>

Hi there, When i do the data relication at the client end (use windows synchronize), the client end use pull subscription to connect to server. At the server end, we only choose all tables to do the replication with client. When I do the synchronization, there is a error poped up, says schema...more >>

hi When I programmatically set up a pull subscription, how do i specify the password that is always going to be used for the publisher and distributor? thanks ...more >>