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