Have been assigned to fix this problem for a client. Basically the logreader is reading transactions at approx 500 cmd/sec and the distribution agent is on distibuting 8 -15 cmd/sec leaving thousands of transactions to process overnight... even delayad til the weekend. How do i speed up distribu...more >>

How exactly are you supposed to get log shipping to work with log backups? I have the production server which backups up logs every two hours on the hour. I have another server which I am log shipping to. I set it up to log ship every 55 minutes. The second time around it failed. I don't g...more >>

Hi NG, I want setup a Transactional Replication with StoredProcedures in MSSQL2k. I have created the Replication in EPM. After this, I created the replication script in EPM. But there are any SPs in the script, where I ask me, if there are realy necessary. Inside the script: ...more >>

does any body have the complete working sample of VB6 for pull replication synchronisation on subscribor side. Server allows anonymous subscription. Regards, -Imran ...more >>

Hello, I've created a publication "rdTest" on SRV1. I setup a share "x", and = give full control to everyone (share and NTFS). That is set as the = snapshot folder. On SRV2 (different network), I setup a subscription to = rdTest on SRV1. This all seems to work ok. Then, on SRV1, I creat...more >>

Hi, Is there a way one can tell when the Merge Replication between the publisher and subscriber is done completely? Because, when replicating large tables, it does take considerable amount of time, and I want to somehow ensure that the replication is completed before disconnecting the subscribe...more >>

Hi all, are therer any other Backup Guidelines for Recovery of Transactreplication than the guidelines in BOL available? thanks Thomas...more >>

Hi there, We're looking at setting up a database infrastructure to handle the following. 2 Physical sites on an 85% uptime VPN Link There are multiple (10+) IT systems for various businesses on both sides of this link. We need to store 1 shared client table and then each systemwill sto...more >>

I must have a fundamental lack of understanding here as i can't believe setting replication up can be so hard! I'm setting up transactional replication, SQL 2000. I want to replicate a whole database but for the moment i'm trying to get it working with one table (or any combination of tables!...more >>

Hi all Can tell me anyone, if the book A Guide to SQL Server Transactional and Snapshot Replication from Hilary Cotter, Publish Date June 15/2004 are available? How and where can I order this book. http://www.nwsu.com/0974973602.html Thanks Thomas...more >>

sql2k sp3 Ive got these columns on a previously replicated table and I cant get rid of them. I went so far as to disable Publisheing from the box and still no luck. I also removed the default values and the indexes from them. I also tried sp_repldropcolumn. Any ideas? TIA, ChrisR ...more >>

I have an irritating problem with an extraction subscription that expires unexpectedly before it should. On the publication I have set the expire time at 336 hours but the subscription expires much before. It's an SQLServer bug or I'm doing something wrong? The real problem is have to r...more >>

Dear All, I want to syhchronize two MSDE servers on two machines. How can I create the merge replication so that whenever I update a server, the other server can get the data. Therefore, is there any step-by-step guide to create a publisher and distributor in MSDE. Also, how to create ...more >>

distribution agent giving error like unable to update sp... can any one suggest which data will delete from which talbles and replication should work normally. ...more >>

Hi I have a central DB with several branch DBs. The plan is for each branch to pull a merge subscription from the central DB each night. My problem involves replicating 3 tables: Customer (has FK to Branch and FK to Address) Branch (has FK to Address) Address The Address table holds ...more >>

I have a merge replication of some tables between two servers. Something curious happens. When I insert a register in a table in one database, then I wait and the other table in the database doesn't update the new register and I refresh the view in my original database and the record I inserted i...more >>

Are there any stored procedures available to alter indexes while Publication is enabled? What is sp_addscriptexec used for? thank you, bob ...more >>

Thanks for the reply Paul. Originally, I think most of our FK's were created without "NOT FOR REPLICATION" being set. Then later I went back and through Enterprise Manager, unchecked the "Enforce relationship for replication" option on the FK's. However, I've also tried deleting the FK's we'...more >>

I hate replication, it's given me nothing but endless amounts of problems, headaches and people who are completely pissed at me that they are not getting there reports. I want to move to log shipping, my question is to those of you who have used both. Is this really reliable, is it going t...more >>

My group has been given the task of developing applications that remain in constant synchronization with other instances of themselves running at remote locations (very remote locations on a WAN, e.g., some in Florida, some in Washington state). For example, Process A and Process B know what Pr...more >>

Anyone know where Hilary's book can be purchased?? I checked Amazon, but no luck....more >>

Win 2k & SQL 2k I have trans & merge replication between several remote sites and my main office. On a couple of the Replication Managers, an error is being reported on a publication. When I expand the dist agent & the publication folder to the actual publication, there is no error. I ...more >>

Hi, I am new to this and need any kind of help or references that you could think of... I have a merge replication going on, on sql server 2000. I have front end standalone web pages... How do I connect these to the sql server to display information from the merged tables? Any help is greatl...more >>

Hi, Does anyone know if it is possible to mail the conflict tables to an e-mail account say at the end of each day. Any ideas or suggestions are greatly appreciated! Thanks, Jane....more >>

Hello, I have a dedicated distributor, a dual, and I have two production quads and two reporting quads. I set up pull replication in the same way between. Yet one is working find while I applied the snapshot to the other and it's taking 12 hours and the distribution agent is just pat...more >>

Hi All , I have a database publication used by a number of pull subscribers, and want to automate the addition of new pull (merge replication and snapshot replication) subscribers. This is all working except the bit where I go to the SQL server and add the subscribers to the enable su...more >>

Ok, on the Publisher, all of our foreign keys are marked as "NOT FOR REPLICATION". However, whenever we push a snapshot to the subscriber (usually we only push the initial snapshot and they run off of merge from there unless we have to change the schema) some of the foreign keys on the subscrib...more >>

sql2k sp3 Ive got this error message when I insert data into a Queued Updating Subscriber: Server: Bla, Database ReplTest : ODBC Error:INSERT failed because the following SET options have incorrect settings: ''ANSI_NULLS., ARITHABORT''. Now I see KB article 305333 and thats about it. ...more >>

Hello All- We are doing some performance monitoring of clients. We are running merge replication ( push) on SQL Server 2000. Clients use MSDE. We notice that merge replication is taking 5 connections to the client. I thought that MSDE had a max 5 concurrent connections and then adds a pe...more >>

Hi, I have centralized database application but few databases will be on remote sites and they will replicate/upload there data to the main server. I wan to create primary key as globally unique. If I create GUID(Varchar field) as PK, would it hurt the performance specially on relational tables....more >>

I have a scenario to implement replication. I have one Main server and multiple remote sites. remote sites have MSDE2000 and they have dynamic IP (dialup internet connection). Products table will be replicated to the remote sites and Sales table will be replicated from the remote sites to the Ma...more >>

I'm using SQLDistribution.SQLDistribution.2 Active X within a PowerBuilder App. The pull subscribers intitiate replication from the application. Both publishers and subscribers are MSDE SQL 2000. I get: The process could not read file 'bla bla'\snapshot.pre' due to OS error 5 - UNLE...more >>

Good morning to all ... This is my scenario: 1. We will have a central publisher 2. We will have SQL Subscribers 3. The data can be changed on the subscriber and in the publisher. 4. The central publisher will have 1 database that acts like a central repository for all...more >>

£Â£Õ£Ç£±¡¢ bug1¡¢ whe i use the pull subscription, and start the publishion, and allow the anonymous can subscription, whe initrialized and start the initrialize have't the error, and i try to view the history error records, can find the error as below: Category:COMMAND Source: invaild c...more >>

sql2k sp3 Box1: Publisher. Located at Facility1. Box2: Disaster Recovery Subscriber. Schema identical to Publisher. Located at Facility2. Box3: Reporting Subscriber. Denormalized. Schema not like Publisher. Located at Facility1. The Publication/ Subscription for Box2 will be Queued ...more >>

Hello, I have a merge replication scenario where 1 article is out of sync. Is there a way to sync just the one table that is out of sync or do I have to resyncronize the entire db? Any help would be greatly appreciated! Thanks in Advance...more >>

Hi There, I am using merge replication with identity field in many table. as we are in transcational process, our many client still using access database. I usually import all the data from our main server in access to sql server2000 using DTS. BUT AFTER I REPLICATED THE MAIN DATABASE IN SQL...more >>

Hi! We installed a new router and now the ftp server only works in passive mode. Is there a way to configure the replication agent to transfer the snapshot using PASV? Replication is merge pull. Thanks. -- Carlos Gutiérrez carlosg@sca.com.mx ...more >>

I am using Sql server replication wizard and it create publisher, subscriber and Distributor successfully and also apply initial snapshot and transfer data. but when i try to synchronize manually it returns error "The process could not connect to subscriber "MySubscriber". i am using wind...more >>

I am using Replication wizard and created Publisher with name "Services3 and Subscriber is HOffice with Subscription database is GinFactory1 and using Windows authentication Mode. Subscription is Push Subscription. It create sanapshot and also transfer data in GinFactory1 as soon as Wizard...more >>

Hilarys long anticipated book... When is out ? How much is it ? Would we get a discount :) ? ...more >>

I have used Merge replication with Pull subscription. It works weel if Publisher,Distributor and Subscriber is same Server. But when i try it on two different server then on transfer data using SQL-DMO from subscriber it returns error "Subscription to Publication 'myPublication' is Invali...more >>

Win 2K & SQL 2K I have 15 remote locations that are replicating to a central server. I needed to make a table change(change field size & add fields), at the remote locations so one location at a time, I deleted the publication, modified the tables then recreated the publication and the p...more >>

Hi chaps, We have a problem with the snapshot application (sql 2000 sp3). This runs on tablet pc's connecting with very poor RAS line quality and potential for line drop outs. If the line drops out during the application of the data (bcp) the subscription database is left with no data in the sub...more >>

first i established transactional replication between two servers with sqlserver2000 and sp3 configuration.now i need to establish merge replication between both the servers on different databases. can i establish merge replication with out disabling the existing transactional the same distributor...more >>

Hello. I have an continuously merge replication across internet and VPN. I got an error as: The process could not check existence of generation at the 'Publisher'. (Source: Merge Replication Provider (Agent); Error number: -2147201003) -------------------------------------------------------...more >>

sql2k sp3 Is it possible to replicate 1 column into 2? If not, then the questions I asked earlier about date transformations are pointless. I tried it using a DTS package and got: DataDrivenQuery: The query type has already been set by the data pump consumer. It can only be reset if th...more >>

I set up a test computer running Windows 2000 Advanced Server with SP4 called INST. It has Exchange 2000 with SP3 on it and is the only domain controller for its forest. I loaded two instances of SQL 2000 Enterprise, default instance and another called SECOND. SQL has SP3A loaded. I sent up snap...more >>

I have an application that has to do the following 1. Disable Replication 2. Run Database Changes Script 3. Enable Replication again. I have the scripts to enable and/or disable replication, but I was wondering if there was anyway to retrieve the data, log, and replication folder ...more >>

sql2k sp3 Ive got a db that Im going to need to replicate offsite for disaster recovery. But I also want to replicate it to a denormalized database with transformations for reporting. The table structures are different on the reporting box which is why I will need transformations for ...more >>

Good morning to all ... I am trying to delete a suscription in EM. I can not find the publication and the databases involved in the replication created for test purpouses, however in the folder suscriptions on my server there is a reference to a transactional publication that is running and ...more >>

In the last two weeks the scheduled replication has failed on the same table. Our programmer has not changed the table. Manual replications are successful. Error message: The process could not bulk copy out of table '[dbo].[syncobj_0x4436433341414546]'. Error details: I/O error while...more >>

My SQL Server 2000 SP3 database gets this error on the log reader: Status: 2, code: 0, text: 'The process could not execute 'sp_replcmds' on 'XXXSQL1'.'. The process could not execute 'sp_replcmds' on 'XXXSQL1'. Status: 2, code: 0, text: 'Timeout expired'. I have figured out that it happens whil...more >>

Hi all, I've run sp_mergedummyupdate at my publisher: USE [Operasi] DECLARE @RC int DECLARE @source_object nvarchar(386) DECLARE @rowguid uniqueidentifier SELECT @source_object = N'dbo.MT_Pengemudi' SELECT @rowguid = {23023B58-9CE1-4F42-9DE5-7F3467E0C6B3} EXEC @RC = [dbo].[sp_mergedummyupda...more >>

Hello All, I am using the SQL DMO COM Library with VB.NET for implementing replication between three db servers programmatically. I am trying to implement merge replication where data in one will be pushed into the other two. I used the sample application provided in SQLREPL to impleme...more >>

Our SQL Server 2000 are replicated across our centers and till date we did not face any problem in Seting up Replication and Migrating the server's . From Past 2 days we are facing a Problem where SQL Server Agent is consuming 100% of CPU utilization. As soon as SQL Server agent is started the CPU...more >>

Hi, I am new to Replication. How to do replication? Do we need to create distributor first then subscriber and at last the publisher? Can tables without primary key can be replicated? Is there any site available which explains step by step replication? With Thanks and Regards, A...more >>

Hi, I'm interested in setting up replication with SQL Server 2000 to a MSDE database for failover purposes. Transactional replication will be used and the MSDE database will only become effective if the first box fails. MSDE limitations are known and have been accomadated for. My question i...more >>

Join members of the Microsoft development team as they chat about what's new in SQL Server 2005 Beta 2. One major new feature that's been announced in Beta 2 is data encryption. Come chat about other new features and changes that exist in this highly anticipated beta of the next version of SQL S...more >>

Does anybody have statistics and proven how merge replication works with large databases 2gb+? Also with large data transfers over modem/lan? ...more >>

sql2k sp3 Ive got a package that transforms a datetime in one table into a char(10) in the other. Im using the Date Time String Function to to this. I feed it in a date and time the way it's stored in a datetime column, it comes out like 07/22/2004. This is all well and good. But once I ...more >>

I am using bidirectional transactional replication with custom stored procedures that can process business logic but that are currently pretty simple. Although all triggers in the db are NOT FOR REPLICATION, all constraints (PK, FK, unique, check) are checked whether the data is modified by rep...more >>

sql2k sp3 I know this one is a long shot but figured "why not"? Ive got an existing DTS package that does the transformations that I want Replication to start doing. Is there way to either: Have Replication use this package as it sits? Mark it as a Replication DTS package? TIA, Chr...more >>

I am new to SQL server...In case you couldn't tell. Under Enterprise Manager, SQLGROUP, Server, Databases, I show three databases that are "suspect" that I need to delete. The databases were manually removed (Permanentley) from the SQL directory in explorer. When I try to delete the dat...more >>

Hi, I have just recently heard about transactional replication, so I don't posess much experience. I have to replicate 1 table among many clients. So far, my application was responsible for this ( it connects to the remote server, checks for new entries in the table and copies them (if any)...more >>

Hi there, I am trying to publish database and replicate using merge replication. Lot of my table have identity column which are pk as well. I crated publication and it not giving me option to enable auto identity range by sql server 2000 itself. could you please let me know what i need to do ...more >>

sql2k sp3 BoxA Publisher. BoxB Subscriber. BoxB is a denormailized version of BoxA for reporting. Not at all for disaster recovery. I will be using NON immediate updating and NON queued updating subscription. I dont want changes made on the Subscriber to make they're way back to the P...more >>

I have a database server in each of the three branch offices. I would like to use merge-replication to synchronize their data. I have no problem doing this with two database servers using merge-replication in every evening. But when I add one more database server to the mix (as a subcriber to th...more >>

Hi, For some magical reason, my database replication has suddenly stopped working. I modified the publication but the Distribution agent will not run; the snapshot does not get applied to the subscriber, and changes made at the publisher do not get replicated. My configuration is: Transacti...more >>

Hi, I've built an application that involves some mobile users with PDAs synchronizing with a sqlserver. The application is finished and before I put it on production, I have to decide the server specification in which it should run in order to run properly and don't have any performance probl...more >>