SQL2000 sp4 trans repl I executed sp_dropsubscription @publication = 'MyPub' , @article = 'ALL' , @subscriber = 'MYSUBSCSVR' I still have a distribution agent sending data to this subscriber for MyPub? Went to EM, clicked on pub at publisher, do not see server in subscr ...more >>

Hi All I am trying to set up transactional replication on a large table (53m records) and am batteling to get the initial snapshot to go through due to either timeouts or locks being caused on the publication database. Is there any way to send the initial snapshot in smaller chuncks or to DTS ...more >>

Hi Everyone, I'm inquiring in the possiblity of using the built-in components/tools of Microsoft SQL Server 2000 or if necessary, 2005 for replication on an unreliable network. I have a machine out in the middle of nowhere that has a local MSDE installed and data from the field goes onto this...more >>

Hello, I am trying to set up a test of bi-directional replication using a copy of our LOB database. I have dealt with the Identity issues using "not for replication" and a seed of 1 on server A and 1000000 on server B. My SQL experience level is pretty much limited to clicking things in EM. I...more >>

We have a 20GB database. Each table has a ID column with Identity and PrimaryKey. Up to Now we only do snapshot replication. Now we need do merge replication. Because the ID column only access by code, I am thinking change the ID column with uniqueidentity data type. but I do not know how to d...more >>

I was creating a new transactional publication and new subscriber on the same server. The snapshot agent works OK, but the Log Reader is giving this error The process could not execute 'sp_repldone/sp_replcounters' on 'SPRS76'. The server name is sprs76. I am now trying to remove the publica...more >>

Hi, We are trying to implement merge replication from pdas to a sql 2005 server. The basic setup can be seen here http://i93.photobucket.com/albums/l56/matt_woodcock/pda_connection.jpg The problem we have is the IIS server requires access to the sql snaphot via a UNC connection. The...more >>

Hi All, I have a replication requirement for which the best approach by far is to use merge replication. However, this will leave us in a situation where we have a single point of failure. Does anyone have any experience or ideas about developing bespoke code to monitor the publisher and, w...more >>

Hi all, I'm new to Replication. I'm receiving transaction changes through a Replication - push Subscription scheduled every 15 minutes. I would like to pull information on this using sql. Where is this data stored or how do I get this information. Succeeded, fa...more >>

We're doing transactional replication on SQL Server 2000. We want to manually synchronize the subscriber, and execute sp_addsubscription with the @sync_type = N'none' parameter. Is it possible to do this, but NOT have the distribution agent start automatically? We want the subscription star...more >>

Other than the obvious answer i.e. updating system tables is bad, has anybody else successfully updated sysdatabases.category to allow the move of the distribution database in sql server 2000 service pack 4. The reason I ask is that I have done so in a production environment to allow for be...more >>

Hi Hilary, I noticed in a previous thread that you state that "Queued updating does not scale well when you have a significant portion of your DML occurring on the subscriber" - could you explain to me why that is? Regards, Lauren...more >>

Hi, I keep reading that transactional replication doesn't handle conflicts. I have also read that transactional replication with updatable subscriptions does handls conflicts and that this resolution is configurable. Which is the right answer? I am thinking of setting up replication to use ...more >>

Hi All, I am trying to setup Transactinal replication but always receive the same error messages; 21074: The subscription has been marked inactive and must be reinitialized at the Publisher. I did it but in vain. Moreover when I try to create a new subscription clicking on 'Push New Subscri...more >>

Hi all, I want to create a agent job to monitor the log agent and distribution agent regularly and I found system table msreplication_monitordata. According to BOL, it contains 'isagentrunningnow' which indicates the agent status. However, the field 'isagentrunningnow' is all 'NULL' in my s...more >>

Hi all, I found that the distribution agent was stopped unexpectedly for transactional replication in MSSQL2005 and there is no error captured in the job history, replication monitor or event log. I can only find out the suspect entry in trace when the the time of agent stop. dbcc increm...more >>

I develop Applications for mobile laptop users, using Access databases. They never see a LAN, and therefore only way to exchange data is the internet. Until now I have used Access internet indirect replication, unfortunate Is Access not as robust and stable as wanted. Question, is it possibl...more >>

Did Hilary write a book on replication? Atle ...more >>

am getting the error in the replication monitor Error 21776 was not found in transpublications collections and also I see the error description change to distributionPublishers collection.. how to overcome this issue ? I have restored a db backup on to a replicated database by mistake ...more >>

Hello everyone, I have error reporting SP to read msrepl_errors and sysreplicationalerts. It runs on the distributor. Here is a select portion of the script: select a.time, a.error_id, CASE a.agent_type WHEN 1 THEN 'snapshot' WHEN 2 THEN 'Log Reader' WHEN 3 THEN 'Distribution' WHEN 4...more >>

I have a publication created on SQL server 2000 enterprise server. Dynamic Filter with HOST_NAME() and filter extended across 63 articles to replicate. my subscriber is running on windows XP and is controlled by a .NET application running on the client. Using the SQLMerge ActiveX Object. ...more >>

I have recently had a SQL Server 2000 server upgraded to SQL Server 2005. Replication was running successfully to another server which is still SQL Server 2000. Since the upgrade to SQL 2005 I have been unable to get Replication to work. The server that I am replicating to has not yet been ...more >>

Hi, I'm running a SQL 2005 server as a standalone distributor which forwards data to several subscribers, from two publishers. For my performance monitoring application I run a proc every 10 minutes to check the status of the commands in the distribution database as follows: select @@Ser...more >>

Hi all! i'll go directly to my problem. Our main db server is in Paris,France being replicated here in the Philippines. during peak hours ,which is around 9AM-3PM(PARIS TIME), replication takes more than an hour to finish. i know this is intolerable that's why im here to seek advice,tips...more >>

Hi All, I woul like to clone a replicated subscription database onto a new server. The following are steps that I intend to follow: 1. Set publishing database to Read-Only mode 2. Perform a final sync 3. Backup the subscribing database 4. Restore the backed-up database to the new server 5...more >>

Hi. I have set a replication for 2 minutes for OLTP scanario. After that time I've a huge data to replicated that takes some seconds. Now problem is that at that time online users see different data at different time during merging process. I'm running a small application in aspx thats show me r...more >>

Hi, i have previously attempted a transactional replication with updatable subscriptions which i couldn't manage to do so i decided to go with straight transactional replication which i managed to do but i had several issues as an outcome. Firstly any tables in the Database that existed ...more >>

Hi, Can somebody elaborate on how to get more information from the Merge agent errors? I'm programming QSl 2005 Express web sync merge use the RMO 9in a .Net page) using the Agent.Synchronize() method which returns the ubiquitous 'Subscription expired or does not exists'. I've verified my re...more >>

Hi, I am having Windows 2003 and SQL Server 2005 Standard Edition on both my Servers. I am new to SQL Server, I wanted to know if we could replicate data between two SQL Servers. Best Regards ...more >>

We are experiencing an issue with Merge replication in a SQL 2000 to SQL CE 2.0 scenario. The issue relates to getting an excessive number of deletes being sent to each subscriber based on changes made by other subscribers. For instance, the following applies each user has access to all...more >>

Hi i am using SQL-Server 2005 & WinXP(SP2) on two machines, try to set the Merge Replication between them(with no Firewall) Server 1 : Distributor + Publisher Server 2: Subscriber the truble starts when i try to Synchronized i got the following error The process could not connect to Distri...more >>

Hello, I have a question regarding upgrade of database schema in a merge publication between sql server 2005 and mobile devices using sql mobile. The publication does not use dynamic or static filtering. When I add a new table and replicate the changes to sql mobile devices that have al...more >>

Hello, is it possible to compress an sql mobile database on mobile devices ? Is it the real used size that we can schow in explorer or are on mobile device some unused spaces in the database like insql server ...more >>

Hi, I want to publish a table based on the ProductType column. For example, subscriber A receives only row that have ProductType=1, and subscriber B needs ProductType=2. Should I create separate publications for each subscriber? Thanks in advance, Leila ...more >>