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