Hi Guys - I am trying to understand how merge replication works. One question that I have is this: after the intial snapshot is applied to the subscriber, does the Snapshot Agent at the publisher generate a new snapshot every time the Merge Agent runs (although it may not apply it to the sub...more >>

I know that Enterprise Ed is required for Log Shipping. But is that on both boxes or just the primary? Also, any links to people that have wrote they're own LS would be appreciated. ...more >>

Dear All, I can successfully create merge replication on the same computer with two database instances. However, it didn't success if I replicate over two computers. I use push subscription and the subscriber seems nothing to set (set the replication on the publisher). Therefore, h...more >>

I finally got log shipping going, however now that we have a warm backup I want to do the Full Backups off of this rather then off production. Is it possible to do this or would it have to be in a fully restored state to do this. Also would the applys of the shipped logs have to be turned o...more >>

I got a big problem with the Merge replication. detail as below: Failed to enumerate changes in the filtered articles. Category: NULL Source: Merge Replication Provider Number: -2147200925 Message: Failed to enumerate changes in the filtered articles. Category: COMMAND Source: Failed Comm...more >>

Im trying to avoid using Replication for Disaster Recovery for the typical reasons. Log Shipping requires Enterprise Edition. Veritas has a product called Storage Replicator for under 2K per box. It mirrors from one box to the other. It sound too good to be true. Why wouldnt someone use th...more >>

sql2k sp3 Ive got a Publication with a Subscription that is Immediate Updating with Queued for Failover. I tried to run sp_repladdcolumn and got: Server: Msg 21381, Level 16, State 1, Procedure sp_repldropcolumn, Line 277 Cannot add (drop) column to table 'transdtl' because the table ...more >>

Hi I am trying to set up a transactional replication scheme with immeadiate and queued updating.. Everything is working fine except for one table when i include it as an article I get the following error from the Distribution Agent: Implicit conversion from data type text to nvarchar is not allow...more >>

Win 2K & SQL 2K I have several SQL servers replicating to one server and I need to add a field to a replicated table can I..... Add the field to the subscriber, then via the Properties- >Filter Columns->Add Column to Table add the same field to the publisher?? Will this cause a problem...more >>

Hi, I'm doing horizontal partition with partition key as an integer datatype.It's a part of primary key also.When i search for a particular value, it's fetching correct results ,but if we examine execution plan all the partitions are searched for a particular search. Please help me to fetc...more >>

I need to set up a seperate database to use for querys (MIS etc), where i want the second database to be in synch with the master database at all times, from books online i figured i could use either of log shipping or replication but cannot see which one is better suited for this task, if anyone ha...more >>

Hi all, we are moving our database to a new server and I'm wondering how I can move my DTS packages, too. Can anyone point me in the right direction? Thanks Andreas...more >>

Hi, I have a SQL 2000 server replicating to SQLCE devices and all was working well. The subscription was deleted in error today and now our users cannot upload their data. We use simple merge replication. I wonder if it's possible to enable the CE users to upload data again or is it a los...more >>

I have one maintenace plan that backs up the transaction logs to a network drive: \\ds1\e$\backup\db1\transact My log shipping is not working the LSN are not lining up. I'm guessing because it's pointed at a local drive: E:\SQL\Logs My question is this the cause of my problem do both ma...more >>

Setting up a transactional replication on a windows small business 2003 server. I have set this up in the past with Windows 2000 server fine (same database) but this is the first with 2003. Did everything as normal eg set up Distribution as normal with all defaults set up a database as a transa...more >>

Hi there, Suppose I have a server at the office which is a publisher and a few laptops with subcribers (Merge replication). If the users of the laptops need to go on the road to do some work and would like to be able to synchronize their changes with each other before coming back to th...more >>

Hi, I want to set up a transactional replication between 2 sqlserver2000 databases. Can anybody say me the ports I need for the replication. Tanks Jeanette ...more >>

> foreign key constraints cause replication not to work I've just setup transactional replication. When i push out a subscription i get errors because it says "The constraint 'PK__Invoices__123EB7A3' is being referenced by table 'ExternalTrans', foreign key constraint 'FK__ExternalT__Invoi__5...more >>

Hi All, I'm developing a (Client-Server)database application in VB inorder to work in wireless environment (CDMA or WLAN). The problem i'm facing is, though the wireless network are not stable as compared to wired networks between Client & server; I'm getting an SQL timeout error. Does...more >>

We have a US online business that is growing internationally. We have a data model that allows us to easily split countries to their own instance or own physical server. A high volume of reads are expected from our web servers so we feel that by spliting reads and writes to separate servers, ...more >>

Question about replication issue Actually I'm using replication with Interbase/Firebird, I have a problem and I wanted to know if someone knows how to solve this, and if people from SQL Server and Oracle replication knows if this happens too with that engines (I hope not) I start de...more >>

I want to to set up a database which publishes to several subscribers. Each subscriber only wants the rows from various tables relevant to itself. The subscribers treat the information as read only and there are no updates replicated back. Despite this not being a rocket science implementa...more >>

Hello all, I am try to implement Merge replication just like this article shows for transaction type replicaion http://support.microsoft.com/default.aspx?scid=kb;EN- US;319649 using SQL Snapshot and SQL Distribution Control with Visual C# .NET First ..I dont see Use a Distribution Age...more >>

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