We have merge replication set up between a SQL Enterprise server and an MSDE instance. We modify both databases through an inhouse app. Things were great until after one synch a whole bunch of rows mysteryously disapeared from the server. The kicker was that MSDE instance had no changes made t...more >>

Hi, I have a table with a tinyint (identity column). The current value in the table is 2. And if I check with IDENT_CURRENT the next value is displayed as 3. This table is an article in a merge replication. In EM if I check this article the next value is shown as 127. And this is leading...more >>

Of course I get the error AFTER I start rolling into production!!!! SQL Server 2000 SP4 and laptops with MSDE SP4 using MERGE with PULL. There must be a bug in creating articles: -- ****************** Table Contact with Int16 Identity field on primary key PRINT 'Table Contact with Int16 Iden...more >>

Hi! Anyone knows howcome i end up with more records in the subscriber than in the publisher? I'm using transactional replication, and the subscriber is a standby server, no inserts are done in this server. Any suggestions? Thx!...more >>

Hi, I was hoping to get some advise on my SQL 2000 server: I would like an automatically updated copy of the main database kept on the same server. Any changes made to this copy would NOT be synchronized to the main database, however, changes made to the main database need to be immediatel...more >>

Dear All, I'm just configured transactional replication. I have 2 DB Servers, OLTP Server and Reporting Server. I uses transactional replication to replicate the data from OLTP Server to Reporting Server. I configured the replcation to use Push Subcription. I set the schedule every 3 minute...more >>

I have setup multiple merge replications that are continuously updating. Now, we need to have laptops in the field that connect occasionally that will merge. Because of that, I assume it needs merge PULL subscription. I have had tons of problems and it has never worked. Right now it seems to a...more >>

Hi, I have set up one laptop as the Distributer/Publisher. Went through the wizard and set up a Publication also, used Pubs. Then registered another remote laptop that I can see via the network, and it can see me. I went through the wizard again and set up a Push to that laptop. Said it r...more >>

Hi, I am considering upgrading to SQL Server service pack 4 and would just like to clarify. In the readme file for SP 4 if find the following: “Note If an instance of SQL Server is not part of a replication topology, you can back up a user database and restore it on any other rele...more >>

Ok excuse my lack of knowledge in this department and hopefully someone can help easily. When using Merge replication with continuous updating subscribers, it appears when there is a network outage (as everywhere will get sooner or later) that it will not try to update until I manually push...more >>

I created a distributor just fine. At my distributor, I am selecting Tools | Replication | Configure Publishing, Subscribers & Distribution... On my Publishers tab, all I have is the name of my distributor (local sql server) in the Servers list. I do not have a "New..." button as is availab...more >>

Hello - I am a newbie to Replication. Can I setup Bi-Directional replication without introducing the guid column on the subscriber? All the tables have Primary Keys. Thanks. -A ...more >>

which is better? push or pull? this is for transaction replication. ...more >>

Hi all, got a feeling its not possible because ive looked for sp's, and there dont seem to be any, is it possible to add indexes with merge replication in place? Thanks Andrew ...more >>

Hi, I'm pretty new to SQL Server 2000. I'm working on a solution for replicational transaction. I have setup a test environment, which works quite well, except for one thing: I've noticed that during the setup of the test environment every published table is extended by a column n...more >>

Is it possible to have a message or notification if/when conflicts occur? Is this art of any standard resolver or does this require a custom resolver to be created? TIA Tony S. ...more >>

I was able to successfuly retrieve a snapshot via FTP but the subscriber says the snapshot .cab within the folder is invalid. What would make the file invalid?...more >>

Hello all, We're using both Transactional & Merge replication between our main SQL Server 2KSP4 Enterprise and Sales Rep running MSDE on their laptop. I'm currently investigating some problem (Not related to the replication itself) and would like to know if there is a way to see what was...more >>

Hi, I'm fairly new to SQL Server replication, so please forgive me for asking what may be a very simple question. I've had trouble finding a basic down-to-earth answer to the following problem, however. We have a very "busy" (in terms of both reads AND writes), fairly large (1GB) databa...more >>

Hi, all. I am use SQL 2k. I need to migrate data from production server to another server for customer to review, and the data can be one day delay. Our database size is about 35GB. Should I use Replication (whick kind will be best) or just to Restore the backup file from Production database....more >>

i am using RDA to synch data between sql server 2000 and my PDA. i try to get a parameter list according to the group of a user in my program. my query to pull is something like that : "select id ,name from parametertable where groupid in ( select g.id from grouptable g inner join usertable ...more >>

Hello, I have several servers SQL with replications they are a priori, configure all similar, nevertheless on the one if I change the password of the account "sa" replications are not done any more. Here is the message of the log " The job failed. The Job was invoked by User sqladm. The last...more >>

how to tune up transactional replication in order not to make my server performance being slow ...more >>

Have created Merge replication between a server and internet remote client (with SQL Server 2000 also installed). Have setup TCP/IP aliasing. When the Merge Agent runs the articles seem to update the remote Subscriber, however, the agent suddenly stops saying:"The subscription to publication '...more >>

Whats the difference between @schema_option = 0x0000000000000073 and 0x0000000000000071 for sp_addarticle ...more >>

If I change my Replicated db to Read Only, will this result in any = adverse effects for Replicating to this db? I don't want users to have any access to the db other than reporting, = and I read on sql server performance: "If you have a database that acts as a datamart or data warehouse, set ...more >>

Hi All, I have a bi-directional transactional replication between two SQL Server 2000 box. After I reboot the publisher, the Queue Reader kept failing, saying "Queue Reader Aborting, the step failed, error 14151, state 1". And the worse thing was that I could not restart it. It would fail i...more >>

There is an option to allow the initial snapshot process to not lock the tables. Any thoughts on using this? Will I be able to capture transactions that occur during the snapshot process?...more >>

Hi, I posted this a while back but had no response. I wonder if anyone can help. I am using transactional replication. CREATE TABLE T1 (LogID INT, Quantity INT) Table T1 is an article to be published. I only want to publish rows that have a quantity > 5. The initial snapshot filters rep...more >>

Greetings, I moved my complete database with Robocopy to another testing site. I want to set up Snapshot Replication, but there is no option saying subscriber already have schema and data. is that must that when ever we are setting up Snapshot Replication, we must have empty database at...more >>

I will be doing this all via EM since I don't know much about sql. I want to move a db that is being published on one server to another. I will configure them both to use the same distributor so I am pretty sure this is possible. tia -comb...more >>

I have a question regarding Replication Alerts. I have set up alerts to trigger in the event any of the replication = agents fail. I set this up under the Replication Alerts section of the = Replication Monitor. I've had actual Distribution Agents fail but yet I receieved no e-mail = notifi...more >>

Hi All, What is the best scenario for seting-up database replication in my situation? I have two computers, each computer has... -W2K, IIS5.0 Web server -Cold Fusion 4.5 Web Application server -SQL Server 7.0 database server -Multihomed IP Addresses using Network Load Balancing ....If ...more >>

Greetings when i am setting up snapshot replication: "yes, intialize the schema and data". i dont want to drop my subscription database tables and data. "No, subscriber has already has the schema and data" is not high lighted. why is it so. when i created publications i haven't checked ...more >>

Sorry, I forgot to ask one more question: I’ve got some pretty good sized tables that I’d like to use for concurrent replication, i.e. concurrent snapshot replication. (I hope I’m using the right term, but I’m talking about where the transactions are immediately sent over to the su...more >>

I want to use what I believe would be called concurrent snapshot replication and by that I mean that any changes to one of the articles will immediately (or very shortly) be pushed over to any subscribers. Here are a few "feasibility" type of questions: 1. Do you have to have a key on all...more >>

Win2003 server msssql: 8.00.760 sp3 I have a ms-sql to Oracle replication and it works fine mostly. The replication is running over the Internet. In some cases the internet line is down for a while, in this cases the REPL-Distribution Agent is stopping. Then I have to start this agent manu...more >>

I have a question regarding Replication Alerts. I have set up alerts to trigger in the event any of the replication agents fail. I set this up under the Replication Alerts section of the Replication Monitor. I've had actual Distribution Agents fail but yet I receieved no e-mail notific...more >>

I'm trying to setup log shipping for a failover system but to date without any success. I've registered the 2 servers & monitor server, shared backup folders, ensured the database is in full mode but when I run the Wizard I get right to the end & when I press finish it either hangs or SQLServ...more >>

Newb question: how to configure biderectional transactional replication in sql server 2000 -- Message posted via http://www.sqlmonster.com...more >>

I'm want to setup merge replication ( sql 2000 ) where one sql server would be installed with a hosting provider & other would be in our office. I'm able to setup a test setup in my office between 2 servers which are in same NT domain. I have queries about how to setting up merge replication...more >>

Hi, We're using merge replication between a Sql Server 2000 Publisher and Subscribers on PocketPCs running Sql Server Ce. One part of our data sync scheme deals only with newly created data on the PocketPC. For this we have an upload-only replication that sends the new data from the device ...more >>

Hi All, I have two SQL 7.0 servers in a load balanced Web environment that I want to replicate changes back and forth to each other so that the two databases are always in synch. I have setup a publisher, distributer, and subscriber with two-way immediate update replication. Replication is wo...more >>

We have two notebooks doing Merge replication (PULL) from the distributor. We use the Active-X merge from ACCESS. Can the subscriber know the results of the replication? I now go to EM on the publisher and look at the Merge Agents to see if there were conflicts, then to the conflict viewe...more >>

I'm trying to find out if it is possible to set up transactional replication over the internet (non-trusted domains) with a remote distributor which is also a subscriber, and one additional subscriber. Initial snapshot should be delivered using FTP. Is this possible or do the distributor and p...more >>

If i want to my test server database should be in sync with my prod database, which one is the best. after complete data sync i dont want any data updates. i am going to setting up only one way, from prod to test. please advise if any risks or issues...more >>

i am interested in creating a script for every table which will write logs as to which information was deleted or updated in a table and by which user. is this possible and if so what are the implications interms of cpu usage and machine impact....more >>

How update publisher db in case it fails ??? I have transactional replication of on database one publisher(sql server 2000) and one subscriber(sql server 2000) distributor is on the publisher server. The data published to subscriber every 1 hour. The web application works only with databa...more >>

Can SQL's service run as a local admin if it's replicating? Or does it need to run as a domain admin? SQL 2000 thanks, Don ...more >>

We had a two-site system go badly wrong as a result of something. The net result of this was that the publisher had to be completely reformatted and reinstalled. The server has, as a result of this, been given a different name (went from being a named instance to not being one). Currently the ...more >>