Big project is at risk if anyone can help it would be great. This occurs after backup/restore of a merge pull subscription. I have read but am not sure of its validity that you can not use the nosynch option with merge pull subscriptions. Is there anyway to avoid marking the subscription for re...more >>

Hi NG, I use transactional replication (setup via stored proc.) All Repl-DBs have their data. No snapshot is needed. Is an initial snapshot necessary, if it will never used? The main question is: Is the proc: exec sp_addpublication_snapshot needed, if I setup a transactional replicati...more >>

How do I buy your book on merge replication? The site doesn't really explain. Thanks for the pointer in previous posts. ...more >>

I'm trying to accomplish what is in the following article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;320499 After restoring a publisher database, starting a merge-agent results in the error: The job failed. The Job was invoked by User sa. The last step to run was step 1 (Run a...more >>

Sorry for the crosspost!! I need a way of replicating from an Access Database to an SQL Server via the internet. It is Access 2000 to SQL Server 2000 Standard. I would like this functionality to be fairly flexible (which is probably asking a lot) so it could work with Access 2000 upwards, as I...more >>

These errors occur at the subscriber. First, "The merge process could not query the last sent and received generations" is generated, then immediately afterwards, "invalid cursor state" is generated. We are trying to pull a new subscription snapshot from the republisher. The subscriber has been ...more >>

I would like to know if i can: 1) Build two indentical hardware PCs 2) Install two identical Windows 2000 and SQL 2000 machines (names and differentes IP addresses) 3) At regular times (twice a day, for example), stop SQL1, copy files (using a file replication tool, like robocopy.exe) to SQ...more >>

I want to setup replication and log shipping at production environment, I have several questions: 1.What's the sequence of setup? replication first or log shipping first or doesn't matter? 2.Does they work fine together? Thanks David Liu moneris.com MCSE MCDBA...more >>

hi all, i suppose to do mergereplication with pull subscription between two servers i.e local and remote server.i can able to establish push subscription with out any errors.when i am trying to establish the pull subscription the following error is coming error 14010:the remote server is n...more >>

Hi I want to republish data in sql server. Scenario is like this. SERVER A SERVER B SERVER C Publisher --> Subscriber/Publisher --> Subscriber Server A publish data (Merge/push to SERVER B) Server B publish data (Merge/push to SERVER C) Can ...more >>

Hi all, We need to setup a simple 2 way replication between 2 independent sites to synchronize the data between them. It looks to us that setting up the native SQL Server replication is somewhat an overkill for our needs. We are worried about the administrative overhead and problems associate...more >>

One of the servers that we replicate to is down for the next 24-48hrs. Is there anyway that we can "pause" the publication, so we do not have to reinitilize when they come back up ? Thanks, -comb...more >>

I have just discovered that tables designated for publication cannot be dropped. I use snapshot replication for large amounts of data but infrequently. Often need to refresh the entire table with new values. I do this by dropping a table and writing a whole new one. Is there a way to disabl...more >>

Hi I am trying to configure this but I am having no luck. I have Three Databases A,B,C which has 4 tables. I want to replicate those Databases to Database D so I have 1 single representation of A,B,C combined. I tried configuring this with selecting Generate Schema and Data and when I ru...more >>

Hi I'm having trouble getting a merge replication to work, this is the error The schema script 'pathto .sch file' could not be propagated to the subscriber. Any ideas how to fix this? Thanks Richard ...more >>

Hi, After disabling publishing on my server, there were numerous merge replication related objects. How do I clean them up. I tried to drop them, but I get a message saying I am trying to drop system objects, and the effort fails. Thanks, Sang...more >>

Hi, New to replication, so this may be a dump question: Can replication be used for one table only? We want to keep one table on ServerA in sync with another Table on ServerB. Thanks. ...more >>

Using the "Pull New Subscription" wizrd in the enterprise manager, I can create a subscription without a problem. Howwever using TSQL I cannot do the same thing: Using this sequence: sp_addSubscription (on publisher) sp_addPullSubscription (on subscriber) sp_addPullSubscription_Agent (on ...more >>

Hello-- I'm am having difficulty setting up what I thought would be something relatively simple to accomplish. I have two client computers running XP, each using a local copy of MSDE2000 to store data. I also have a server running Windows 2000 AS and SQL Server Enterprise. What I'm t...more >>

I added an article to one of my publication with sp_addmergearticle as a no-sync. A subscriber replicated last night with the following error: The merge process could not retrieve column information for table 'dbo.ChargeGroup'. (Source: Merge Replication Provider (Agent); Error number: -2147...more >>

Hi, We are trying to setup merge replication on 2 computers sql 2000 server sp3 (winxp sp1). Central db(subscriber) and local warehouse db (publisher) resides in 1 server and another local w. db resides in 2 server. We have published 7 tables. When we try to insert data into all 7 tables of c...more >>

I posted this message under the comp.databases.ms-sqlserver group and someone mentioned I should post it here: We are using Merge replication with clients from remote offices (SQL 2000, sp3). Recently, I have had a problem with users who are replicating, and they shut down their laptops. The...more >>

Hello, Have anyone come across this type of error, the server is sql2000 sp3. The problem persists even after removing the replication and re-creating from scratch....more >>

Please has anyone experience this issue with log reader agent failing with the error message 'access violation has occured' It continue even if the entire replication was desabled and re-created. One of the server concerned is running SQL 2000 sp3a while the other has no sp...more >>

Dear Friends I am getting the following problem while connecitng to the Subscriber for the merge replication The process could not connect to Subscriber 'NETVIEW'. (Source: NETVIEW (Agent); Error number: 20084) I can ping to the Subscirber and also can add the publisher in the enterpr...more >>

Hi , we are getting this error while replication ... Procedure Date, Line 15 Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). Pls help -- Sunny...more >>

Hi i started a restore on a little db, it is still running (more than 15 mins), how can i understand what is it doing??? Carlo ...more >>

Hello We're looking at another point of presense for our websites. What would be the best way to keep the external sql server updated with current data from the main server? Would a cluster license be required? Thanks for any advice Richard ...more >>

more quest from management, good grief! 1) general replication architecture. question: does repl. copy data table by table or does it get it's data from the publisher's trans. log file? 2) do custom stored procedures take the place of filters entirely? thanks much Jim...more >>

Hi everyone, I am trying to create a Transactional Pull Subscription=20 but I get an error 207 : Invalid column=20 name "enabled_for_syncmgr" Invalid columnname "alt_snapshot_folder" Invalid columnname "dts_package_name". Both The Publication and Subscriber databases are SQL=20 Server 7 b...more >>

I am not sure if these are the correct groups to post this, so please redirect me if there are better ones. Client has a SQL Server db of organizations and member info that is in pretty much constant use at his location. He would like to make the maintenance of adding/editing member info avai...more >>

PLS HELP ME. SOS! Our customer has two fatctories and a marketing center with long distance. So we have to syncronize data through sql server replication. Because both publisher and subscriber can modify data, we use merge replication. But when we tested, foreign key conflicts occured even we...more >>

Hello. We removed a vsql server that nobody ever deleted a replication package from. So the distributor still thinks its there and is waiting on it. I tried to delete it from there but it wants to log back into the vsql server that no longer exist. Is there a way that I can remove ...more >>

I have a merge publication that already exists on a db. I added another server as a subscriber and no errors happened but there is no data in the table. The replicated db and tables exists on the subscriber, the publisher shows the merge agent as a Push with an idle status. I ran the sn...more >>

sql2k sp3 Can someone point out to me the steps to take to use Custom Sync Objects? My Publisher and Subscriber have different schemas which is the reason for they're use. Obviously I need to take into account the Insert, and Update Procs, as well as the Subscriber schema. I could see t...more >>

I have transactional replication going. The database size is about 27 gigs and we purge data every week to keep it around that size. Obviously i want to run dbcc dbredindex after that. What are the performance implications ? Any gothcas ? Regards -srini...more >>

Hi. I was after some advise about whether or not replication (Proabably transactional) was for me. I will have 2 or more databases serving client applications with each client needing to make quite freqent inserts into various tables. The application as a whole cannot afford to go offline...more >>

I was using an "alternate snapshot location" for the storage of my reinitilized snapshot data. All those snap shots have made it to the subscribers. I am now wanting to go back to those pacakges and set their snapshot location back to default (basically the default dir on the distrib...more >>

We have this problem on one of our servers. We tried restarting the agent service but that did not resolve this. Is is so crucial that we identify a maintenance window asap to take care of this or do you think that it can wait a few days? It does not seem to be causing any problems. The machine ...more >>

On my replication server, I receive the following error when the replication server communicates with the subscriber. When running the following stored procedure, sp_mergemetadataretentioncleanup, it allows replication to occurr. However, it seems to be a temporary solution since the e...more >>

Dear all, i have a mergereplication running. All Agents seem to work properly and are synchronizing the client. Now we have had some changes in the columns and i would like to remove the subscription to create a new snapshot. This has worked fine several times before. Now, at the same pl...more >>

Hi, I recently had a problem with a merge replication publication. In some cases when data is changed on a subscriber, the change gets back to the publisher but does not replicate from the publisher to the rest of the subscribers. I checked the conflict viewer and there are no conflicts. I a...more >>

Hi, I am setting up merge replication, and i have found that the system has setup a lot of stored procedures (sel_%, sp_cft_%, sp_ins%, etc) and views (ctsv_%) in my application database. I don't like those SPs and Views to be there... i really would like to move them to another database, h...more >>

I have 2 diifferent applications that utilize the same database. Quite a few of the tables are used by each of the programs. I am trying to figure out how to make merge replication work on both of these without receiving the error I am currently receiving: The process could not drop one or ...more >>

Hi, I have set a transactional replication by Interprise Manager, but when I create a subscriber using "Pull Subscription to ..." it creates it succesfuly and even gives me this message that "you have created the subscription successfully", but it doesn't start replication and gives thi...more >>

Hi, Since Friday morning (6th Aug) in our Production system we've been getting a huge number of generations against a single table "LatestFundPrice", which is resulting in very long sync times (over a 90mins for a job that used to take 55secs). Some clients are even failing with a "failed ...more >>

Hi, I would like to know about the syncronization between two different location (Very far away) SQL server database server Please somebody teach me on this regard as early as possible I am in hurry to know and make use of it Thanks & Regards Antalin...more >>

Hi experts, I wish to document the replication settings on our environment, is there a good way to list the settings on the system ? regards, Diana....more >>