Hey. I've logshipping implemented right now. I'm confused as to why should I not be using Replication instead. Are there any benefits of using Logshipping in place of replication. I understand how replication works and I know how Logshipping works but is one better than the other. Also, what s...more >>

In merge replication, if you add a new trigger to a table, or change one, when is that replicated to the user. They are initiating pulls. Thanks, Steve...more >>

In my SQL Server 2000 Standard Edition. I am trying to truncate the log for the database but i am getting the below message. The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark tr...more >>

We've got a SQL Server 2000 to store the data. There are 2 offices, Office A and Office B. The primary server is hosted in office A and both staffs in Office A and Office B can modify the data in the system. We are planning to setup one more server in Office B in order to improve the performa...more >>

I need a consultant to come to our business to assist in a SQL replication setup. Where would be a good idea to find a reliable one? I would appreciate any help....more >>

I am building an application with a SQL Server 2005 Express backend. I would like to create a secondary instance the database on another server that will serve as a fail-over in case the primary server goes down (there is only the Express version of SQL Server in this picture). I see that repli...more >>

We recently re-initialized a subscriber for merge replication, the snapshot took 36 hours and finished successfully. The problem now is the merge agent is giving the following error while trying to upload to the publisher: The merge process could not retrieve generation information at the ...more >>

Does anyone know of a solution for OFFLINE Data Synchronisation for .Net applications sitting on top of MS SQL databases in an asynchronous, limited and expensive bandwidth (<=9600bps) configuration (i.e. synchronisation data need to be exchanged in the form of files or any other asynchronous ...more >>

i am using merge replication for data sync. in the client i have utility written in vb that use merge object. Clients get the dynamic snapshots. My question is: when i run the job and create a new snapshot for a user, how can i force the client to use this new sanpshot instead of getting ...more >>

Hi there, was just wondering... I setup database replication , creating a publisher and a subscriber..... all seemed to go well. Anyway, my question is... Can Log Shipping be setup accidently while doing this process? I know nothing about log shipping.. and someone is trying to point blam...more >>

Hi all, I have few queries. What is the best option and why? SQL2K EE as publisher and SQL2K Standard as Subscriber SQL2K Standard as publisher and SQL2K EE as Subscriber I have a merge replication (NOSYNC) and very frequent I need to add tables into it. What should I do to add tables i...more >>

We have a SQL Serrver 2000 database that utilizes merge replication. Every now and then the replication process attempts to insert or update tables out of order. For instance: We have a TransactionDocuments table that has a one to many relationship with a TransactionLines table. Sometimes SQL ...more >>

Hi, I've restored a database that had replication on it to a different server without replication. How can I remove the replication objects from this database? I've googled and found nothing so far... Regards paul...more >>

Hello, I have a database which i used to replicate it to a subscriber, but i deleted subscriber and publication and everything that related to it. I don't know why, when i want to delete it, i get the following error message: "Error 3724: Cannot drop the database xxxxxx because it is being u...more >>

Hello, There is a "rowguid" column that was added to the end of my tables, and I have no clue when and why it was added. Actually i had a Merge Replication on this database and i removed it. I don't know if it was generated by SQL Server for Merge Replication or something else. Ant idea ??...more >>

Any reason not to use IP addresses when setting up replication via the sp stored procedures? Thanks, Mark...more >>

Hi WWW Is it possible to do full backup of the database without touching the transaction log? And if this is possible how to do ? We want to do some log shipping but I want to keep to do a full backup of the live database ... otherwise we must switch our backup device from live-server t...more >>

Hi, I have an application that use SqlCeMerge replication to transfer data between mobile devices and a central office server. With the CF 1.0 and Sql Ce 2.0, the replication took only 30 seconds for a "send only" replication, with few lines (near 100 rows). Now with the CF 2.0 and Sql ...more >>

I am new to replication and MSDTC. I have a serverA which holds all the admin data and serverB is the application specific data. I would like to have the data in the ServerA replicated into the ServerB, so the application just used those replicated data as readonly. At the runtime when a ro...more >>

I have a publication say with 5 articles/tables in it . Say i decide to update a million row table thats part of the publication say table1 for eg: And then a few secs later say another table thats part of the publication say table2 just has one row added to it. Is it possible that tabl...more >>

I noticed that the distribution agents are blocking themselves in the distribution database. It looks like this when i do a sp_who2 spid/blocked By: 80/Not blocked 80/80 80/80 80/80 80/80 Is this normal?...more >>

Hey. The subscriber is a SQL 2000 server. It's exactly the same as the publisher in configuration. I sp_dropsubscriber the subscriber and readded it from EM but i still get this error. I disabled publishing and everything but it still gives me this error. 14095, 16, Could not subscribe to...more >>

Hi, Is there a way to replicate data from an SQL Server Mobile database to an ORACLE database? Thanks in advance for your help!!! -- Johann Granados ...more >>

I have read, and it has been recommended here, that in order to improve transactional replication performance I should set the PollingInterval and HistoryVerboseLevel to 0 on both the Log Reader and Distribution Agent jobs. As we are utilizing scripts to enable and configure replication, I wa...more >>

Hello, I have a question I hope can be answered fully. Some time last year, I attended a Microsoft presentation in Dallas and a sql server specialist from microsoft (I think his name was srikan) mentioned during Q&A that SQL Server 2005 has peer-to-peer replication which is a comparable so...more >>

I found a wonderful tutorial article from Microsoft at: http://msdn2.microsoft.com/en-us/library/ms171908.aspx The article includes a walkthrough on "Configure a SQL Server 2005 publication", with detail steps on how to: - Create a snapshot user account - Create a snapshot folder - Create ...more >>

Has another successfully setup SQL 2005 replication over WAN without the need for name pipes nor UNC server name? i.e. using only DNS hostname and IP address for the source and target SQL 2005 servers? If so, can you share how you did it, and what are the firewall ports to open? I need to b...more >>

How do I modify an article's property in a tranactional publication with active subscriptions? Want to change @pre_creation_cmd = N'none' to =N'drop' tia, Chris...more >>

Hi, I did'n want to use default replication mechanism when I initially set up transactional replication between 2 servers (sql server 2000 sp3). However, now I need to change replication to use default mechanism for some operations (inserts/updates/deletes) of existing articles. 1. Is there...more >>

I am attempting to create an anonymous subscription on a new install of SQL Server 2000 (new server). I have successfully done this other instances/servers. Why does the publication, which allows anonymous subscritions, not show in my options? I can ping the server just fine. I am sure I...more >>

I have 2 Windows 2000 SP4 Servers both running SQL 2000. One server is the "active" server and the other is "passive" with the active sending database updates/changes to the passive database. Both databases are in theory identical. So if the active server fails, the passive takes over. I a...more >>

I'm really new to this concept, so i would appreciate a little guidance. I have a database that is stored on a remote server (shared hosting environment). Of course the hosting company says they do daily backups, but I don't want to trust that for myself and our clients. Is there a way ...more >>

Hi, I was wondering whether cascaded deletes or updates would be replicated to the subscriber. The subscriber tables are just plain tables without any constraints. But the publisher tables have FK relationships. On the publishers database, if I deleted a row from the parent table resulting ...more >>

We are in the process of establishing some standard .sql scripts to enable transactional replication with our product and I was wondering if anyone could help me with any “gotyas” that I should look out for. Basically we are going to have two systems, one Distributor/Publisher and one S...more >>

Running SQL 2k / Win 2k I am getting an error on Replication Monitor->Agents->Misc Agents->Expired Subscription Clean up that reads 'Executed as user: ROUSES.COM\Administrator. Invalid object name 'sysarticles'. [SQLSTATE 42S02] (Error 208) Invalid object name 'sysarticleupdates'. [SQLSTATE ...more >>

Hi, The replication log reader failes without any specific reason. Message "the step did not generate any output". Quite long time using replications, this is the first time to get this message. Publisher is virtual sql server 2000 (on windows 2003 cluster), in test phase, should put it in p...more >>

G'Day Some of our customers have the db replicated, some not. (SQL-Server 2000) How can find out, whether the db is published or not without access to the master db? thanks Aline ...more >>