How can I monitor replication, specifically 1. Errors by each agent (distribution, snapshot, logreader) 2. Tables to help troubleshoot errors 3. Undocumented stored procedures to help troubleshoot errors 4. How to back up a transaction log on a database with a long running (replicated) t...more >>

I am using SQL Server 2000 on Windows 2003 Server. I have two identical machines running this configuration. Machine A is primary, machine B is backup. I have setup a merge replication as such: Distributor running on B, publisher on A, pull subscriber on B. These machines are installed at a ...more >>

Hi, This is a silmple Qn. I know it is possible to Replicate thru Query Analizer. But i don't know the steps can anyone help me An ...more >>

Hi , I have set up merge replication between two servers. The process goes through all the bulk copying and applying of some scripts and then end on the error: The process could not make a generation at the 'Subscriber'. Last Command {call sp_MSmakegeneration (?)} I have no idea why th...more >>

Environment: SQLServer 2000 Enterprise w/SP3 Win 2000 Server w/SP3 In testing replication against a copy of our production database, when I run the snapshot agent, it completes with success. When I then run the distribution agent, I get the following error returned: The name ' ' is not p...more >>

Can anybody make a recomendation for 3rd party replication tools for a continious merge relpication? Thanks ...more >>

Has anyone successfully implemented Bi-Directional Transactional replication? The documentation on BoL is very limited and there are not too many info available outside too. We are planning to have active-active SQLServers, that needs dynamic transactional replication. I would really appre...more >>

Hello, We aim to use the current server (w2k,sql2000ent, 2x1ghz, 1gb ram, mirrored pair & raid 5 for data) as a failover machine and upgrade to a new server for production. The 2 machines will be in different countries. Users in both countries will use the production server. If the connecti...more >>

I am building a Pocket PC app against an Oracle back end using .NET Compact Framework and Oracle's sync technology (this includes Oracle Lite on the Pocket PC). The presentation layer needs to also work for SQL Server CE. So I'm trying to make the GUI code generic. To do this I need to confirm ho...more >>

Hi, I am currently running SQL Server SE with SP3 on all of our servers. I recently set up snapshot replication of stored procedures from our main server to all of it's satellites. The SP's are being altered though because on the subscriber, the [ ]'s have been changed to quotes, as in this ex...more >>

hi, I am dealing with merge replication between a remote server and local since last 2 months From last 15 days, replication stops frequently and showing the error message The process could not enumerate the changes at the 'subscriber' Can I know the reason for this? Thanks Soura...more >>

hi all, We currently encounter a big trouble: We have set up a model of synchronization from PDA to SQL Server succesfully. Everything is OK until SQL Server database met a trouble and needed to restore database. We restored a rather old database (1 week ago) and then so many erros appeared...more >>

Hi, I have set up a transactional replication with Publisher, Distributor and Subscriber on diff servers. I want to find out (if any) transactions that have not been replicated from publisher to distributor , and from distributor to subscriber. Can you tell me which tables / sprocs I...more >>

I'm trying to adapt the auto-generated script for a merge replication setup so that it can be run to set up the replication without using Enterprise Manager. I am having one problem: the initial snapshot isn't happening. The script that EM generated ends with a call to sp_addmergesubscription;...more >>

I had created merge replication successfully on 2 of my servers. one crashed (subscriber). After reload, i try to establish the replication again only now i get .. 1722 the RPC server is unavailable... i verified both publisher & subscriber are running the RPC service. any help would be appr...more >>

I'm using stored procedures to recreate an old subscription: sp_addsubscription sp_addpullsubscription sp_addpullsubscription_agent I have to use transactional sql as this is part of installation package to setup my application. The problem is: I cannot find the option in these SPs where I ca...more >>

Hello all, I'm getting unexpected behavior when running DBCC SHRINKFILE on my 9 GB data file. First, it's been running in excess of 10.5 hours now and, second, it is ever-so-slowly *growing* the used portion of the file. For instance, when I look at the 'Space allocated' section of the Task...more >>

We are planning to upsize our Access XP backend to SQL Server 2000. I have tested the process and seems to upload fine. My problem is with autonumber fields that are primary keys and links to other tables. The Access replica numbers them at random so they are scattered from large negatives to ...more >>

Using merge replication, we made some schema changes to the publishing database. The changes included the addition of a 1 column to to different tables, a modification to a view and the addition of 3 contraints. To do this we created a new publication. When I created the subscription for th...more >>

Hello, In the pub proberties, filter columns, some columns greyed out? some tables all are greyed out... what determines this & is there a way to filter these? Thanks! -- Scott Kramer CDS Technologies, Inc. www.clevelanddata.com www.groundzerolan.com www.team501.com ...more >>

I am currently using a group of publications to replicate out to SQLCE via merge replication. I got a few complaints about speed of user devices, so I added filters on my test publication to try things out. I have always filtered columns and had one column filtering by row on a single lik...more >>

I recently discovered the mslogreader_history and msdistribution_history tables (thanks Hilary) and like the info they provide. However, I switched from the default Distribution and Log Reader Profiles and assigned my own. After I made the switch info isn't making it into thes tables? How do I c...more >>

Hi, My development computer has an SQL2K database, with several databases. Most of them not only have actual data but also stored procedures & functions. I need to "clone" specific databases (and their data & stored procedures, functions, etc) into my laptop for transport during my trip...more >>

Hi, I have a database that has tables with Timestamp field. I am trying to do a transactional replication on this db. The wizard changed my "Subscription" table's timestamp field to Binary format. Now, the problem is that a report application (we didn't write it) require this TimeStamp...more >>

Is it possible to replicated multiple tables into 1 table in the replicated db? Someone told me that it was possible to replicate and denormalize at once, and I've never done this nor can I see a way to do it. Thanks in advance. Andre ...more >>

I use the stored procedure sp_addsubscriber to add subscribers. I want to use DNS names of the subscribers. How can I achieve this? thanks in advance, Marco Broenink...more >>

I have several merge replications running pushing subscriptions from one server to the other. After some problems we recreated the databases (se previous questions). However after pushing up all data everything worked fine until we changed the administrator password on the subsciber server. No...more >>

Hello, Is there a way to remove the msrepl_tran columns from tables that have been marked for replication? I've a backup taken from a replicated system that I want to remove all the replicated tables and columns from. I can go through and delete the msrepl_tran columns and constraint ...more >>

Hello, I am getting everything fine at my machine database, for all tables having identity columns I am getting the identity values properly. Using this: declare @test int set @test = ident_current('Track_Changes_Table') print @test However at the client production machine I am not...more >>

hi, hi, I've created a replication on one of my sql server 2000 server. this is a replication with 'nosync' option. I got the following two errors from each of the distribution jobs/agents to each different subscribers: error1: 'Replication-Replication Distribution Subsystem: agent ...more >>

Hi. I work for a company with 40+ remote workstations that synchronize their databases wirelessly to receive new jobs, as well as submit field tickets created on their laptops. This time of the year is our busiest period, however we have some new tables in the database that we would like t...more >>

Paul, Hilary , anyone. Do you guys have a step by step instructions on how to move a db to another publisher without reinitializing? Isn't there like a "no sync" option. I have seen you guys talk about sometjhign of that sort in here. These tables we replicate are too big to have to ...more >>

Hello, When I use the Replication and the Publication mechanism - why is created for every table which I want to synchronize an additional column with the name rowguid? I have already set a primary key for all tables which I want to synchronize. Regards mat...more >>

Hi, I am struggling with this for some time now: I want all records older than a certain period (eg. one month) to be deleted from the subscriber's database. I have created sample database with only one table and one datetime column, just for testing this. The table is filtered: SELECT <publ...more >>

Hi all, I have a problem with replication. I did a search for error number 28549 in this group and find no answer that matched my case. :-( I have used replication for download data from sqlserver to pda. All the tables a independent with each other. No link between them. I have set the -Ex...more >>