Hello: I'm new to replication and need you help with a scenario. 1. We have a central SQL 2000 database and multiple offline MSD databases. Data will be captured in MSDE while they are offline an will be synchronized with the central database when the MSDE machine get online. 2. The DB a...more >>

I have deleted replication but still see subscriber details - how can I remove Thanks...more >>

Is there a way to setup two separate subscribing databases on one machine that each subscribe to two separate publishing databases on one SQL server. It appears that the server can not differentiate between the subscribers, since they are coming from the same port. Is there an Alternat...more >>

What is the correct way to pause and restart SQL Server 2000 Transactional Replication? Thank You, Jim...more >>

Hi Is it possible to set up multiple distribution servers locating on different Hosts for one SQL Server Different database on the SQL server could use different Host acting distribution server for replication purpose Thanks. ...more >>

Hi I am very new to this replication processes, At present after going through all replication docs on the net I am able to understand what replication is, its advantages etc. Now I want to try out Transactional replication - to keep data back up. Since I am new to this area - can any on...more >>

Hello everybody I need to implement a replication over internet and I don't know what specific items I have to configure to do this possible. If anyone can help me thanks very much. Juan ...more >>

Hello all, I am using Merge Replication to synchronize data between 1 SQL Server 2000 box to 500 MSDE 2000 clients with Named Pull Subscriptions. I understand that I need to create a separate Publication for Stored Procedures. But I would like to know which one would be preferable i.e. Sna...more >>

Scene There are two machines with Windows 2000 and SQL Server 2000 msde sp3: Machine 1: name : mach_mai database : db_mai status : Publicator and Distributo Machine2: name : mach_store database : db_store ...more >>

Replication as a realtime backup is the original goal. But after play around with replication and doing some readings, I found this appoach is not very convinient. 1.Auto-increment identity column causes problem. Since we mean to use subscribe DB as a bckup and may bring it online any tim...more >>

I am having trouble posting. Just a test... *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

In SQL server 2000, I have a database that is setup to publish out to a SQL Server 7 database. The problem I run into, is if I setup anything other than check database integrity and include the indexes, it breaks the replication. Does anyone else even bother with using the maintenance plans?...more >>

Hi everyone. I'm have a bunch of SQL 6.5 - 2000 servers that are replicating data via batch insert jobs every 5 mins. I don't know why this method was chosen over standard replication Does anyone have any idea why this method would be used What are the recourses constraints when using replicatio...more >>

After I successful ran the snapshot agent and create the snapshot for a Published Northwind database, the merge agent still not run with the error shown below. How do I fix this problem and get the merge agent to start merge replication with subscriber? Please list the steps to take. ERROR MES...more >>

Hello I have a Windows 2000 Server with SQL Server 2000 with 3 databases duplicatet with merge subscriptions with 2 more Windows 2000 Servers. I have the latests services packs. I am accesing the tables with an Access 2000 application and ODBC. The system was runing perfectly until a week ago ...more >>

We'd like to be able to provide a simple batch file which will transfer an online database to another online location. Obviously, this is simple to do with a DTS package. Can a DTS package be called from the command line? (Failing this, I guess I could write my own program to launch the DTS pack...more >>

Hi, We are currently trying to create a disaster recovery plan. Curently we have a publisher, distributor and a subscriber. The publisher has primary keys and identity checks that are not on the subscriber. We wish to create a script that will apply these to the subscriber. I currently...more >>

I am wondering is there any option I can choose to setup the publisher push everything to subscriber, including created-in-the-future objects, like stored procedures and views? So that you don't need to add every new item to replication articles in the future. Frank...more >>

I have some problem with setting Transactional Replication. I didn't use snapshot to setup initial state, because some tables have Identity column as Primary Key and I don't know if I if the snapshot will be exactly the same as source table, other than this Identity PK problem. So I u...more >>

Hello folks, I am very new at SQL Server as well as replication. We are trying to setup Transactional Replication (TR) of all tables between 3 SQL Server 2000 databases using queued updatable feture. We are using SQL Server Enterprise Manager GUI to setup replication. One site(A) will act a...more >>

Hi, I'm deploying an application on a Pocket PC and I've using the replication between SQLServer CE and SQLServer 2000. I've two publications in the same data base on SQLServer 2000. The two publications are different. One is a ExchangeType.BiDirectional and the other is Exc...more >>

Hi, Can someone tell, if I use Merge Replication option for database replicate from A to B site, normally the data will loading, update, etc from A site, only once A site server down for some reason, I can use the B site for data loading, update, etc? And after A site server up, only da...more >>

When creating replication from MS DB to MS DB, there are afew store procedures generated, that allow to create custome replication. For instance chnage the field names of tables etc... This does not seem possible with heterogenous DBs If I wanted to replicate an MS DBtable to a SYBASE DB table and...more >>

I need some help, I have 2 SQl 7.0 servers, one running on NT4 Sp6, the other on W2K Sp4 The NT4 is the LIVE system, the W2K server acts as physically available backup server I want to set up a scenario whereby if the NT4 server fails, all users can be redirected to the W2K server to view th sam...more >>

Hello.(SQL Server 2000(SP3),W2K) I would like to create a new subscriber on remote machine but i could not. We get the error "[298] SQLServer Error: 8198, Could not obtain information about Windows NT group/user 'domain\username'." This user is a member of Adminstrators group and has full perm...more >>

I have an MSDE-2000 replication client and SQL Server 2000 publisher. The subscriber has set up a merge pull subscription locally using: sp_addmergepullsubscription and sp_addmergepullsubscription_agent. Then it sets itself up at the publisher by calling sp_addmergesubscription on the publisher d...more >>

Hi I have setup Transactional Replication, i have one question. If you are doing with subscriber already have same data and schema, how you will set up TR between the databases. Please give me valuable suggestions Thanks John....more >>

Hello, I have the filegroups on the target sql2k machine the way I want them on it. When I run a default replication it changes these filegroups and puts all the data to primary. I believe there was a setting somewhere that would allow the data to be replicated based but leave the filegrou...more >>

We need to implement a disaster recovery site. What would be better? To use replicaction or log shipping? Thanks, Alan....more >>

Problem: Merge replication with inserts into a parent – child relation (order – orderdetail) schema generates a lot of replication conflicts. Current Situation: In a live environment Merge replication has been setup for one publisher and six to eight subscribers. All schemas are exactly the ...more >>

Hi The Scenario i I have One location (One Branch) where users are performing insertion/Deletion/Updation I want that daily at evening or whenever I want then perform update to HeadOffice. Donot copy whole db just update (reflect changes Insertion/Deletion/Updation operations performed only at ...more >>

I have a transactional replication setup for my database. Only 70% of the tables are configured for transactional replication as these are the most frequently changed ones. this works fine. I want to resynchronise the the whole database using the snapshot once every week as a scheduled job...more >>

I have a replication issue between SQLSERVER1 and SQLSERVER2. SQLSERVER1 is the distributor in a remote distributor replication configuration. SQLSERVER2 is the publisher. The log reader has been showing errors all morning. When I try to start the Log Reader Agent it looks like it is processing ...more >>

I have disabled and removed replication from the server, (2k sp3) and I am still unable to drop and recreate one of the tables that was under replication. I've gone through the master DB, the replicated DB, and all sorts of other information trying to figure out how to completly remove any reference...more >>

I have two SQL Servers running, each on a different machine in the same domain. On one machine I have a Publication set up and on the other machine I have made a Pull Subscription to this Publication. It all seems to get setup OK but when I select 'Start Syncronizing' on the Subscription I am ...more >>

After following the wizard's instructions for setuping up a distributor, I get "SQL Server Enterprise Manager could not configure XXX as the Distributor for XXX", followed by Error 14114:'[null]' is not configured as a distributor No error codes, nothing to indicate what I'm doing wrong Where do...more >>

You'd think I'd have this replication thing figured out by now but I'm now struggling with snapshot delivery errors. Here's my setup and hopefully someone can point out my mistakes. Publisher and Subscriber are on different servers, subscriber is using dial-up connection Merge Replication...more >>

You'd think I'd have this replication thing figured out by now but I'm now struggling with snapshot delivery errors. Here's my setup and hopefully someone can point out my mistakes. Merge Replication - Pull Subscription Publisher 1. Local NT account called 'SQLAgent' 2. Snapshot folder c...more >>

After turning off all Replication and deleting all subscribers to a database the columns with not deleted. >>>name=msrepl_tran_version Is this normal and if it is can I just delete the column??...more >>

When I syncronize my tables, I get this error: Cannot insert duplicate key row in object 'POHFIL' with unique index 'IPOHFIL0'. (Source: CMTSQL2 (Data source); Error number: 2601) What do I do? the help was not much. I am trying to replicate tables between two SQL servers. Thanks for an...more >>

Hello! I'm trying to drop an article from transactional replication ... I acctualy managed to do it, but I always have to reinitialize all subscriptions which takes quite long. Is there a way to drop an article without droping full subscription and reinitializing snapshot? Kind regards, D...more >>

Hello everybody I'm trying to use the Northwind CE example and I have some problem I try yo explain how is configured my system I configured the emulator as follows: Connections: Internet Settings; Work Settings; The internet Network adapters: DC21X4 ethernet driver with "use server-assigned ...more >>

Hi The code below is the syntax for creating a stored procedure to add a column to a published database. sp_repladdcolumn [ @source_object = ] 'source_object' , [ @column = ] 'column' ] [ , [ @typetext = ] 'typetext' ] [ , [ @publication_to_add = ] 'publication_to_add' ] ...more >>

Hey Group, Hope somebody could help me? I have a VB.NET app whcih look at a SQL server for its database, I would like to be able to have a copy of the Database on some Laptops, I don`t want the user to be able to update the information on the Laptop, just be able to view it. I would like...more >>

I'm trying to configure replication for server 'PMC5_SERVER\DATAAGE'. When I START the Snapshot I get the error: Login Failed for user 'my login user name'. The process could not connect to Publisher 'PMC5_SEVER\DATAAGE' I have tried logging into the server with 'my login user name' and it works ...more >>

I have a Transactional Publisher and a Merge subscriber (for a different publication, obviously) running on a server. Can I have this server in the Simple Recovery model or should I have to use Full Recovery ? Thanks S.Kumar ...more >>

I'm interested in replicating data from server1.table1 to server2.table2. Table2 has a different name and structure than table1 Two Questions 1. Can I replicate to a table that has a different name 2. How can I create a DTS package to transform the data to a different structure Thank you ...more >>

SQL 2000-merge replication Publisher 1, subscriber's A & B. Publisher 1 is to be update by both subscribers. Inventory application. Item1 is contained in both of the subscriber's (individual) database. The record at Publisher1 for Item1 is to be the aggregate total of transactions tak...more >>

If I manually "re-initialize" a subscription, I get the option in the dialog to upload changes first (checkbox). My snapshot agent runs once a week. Will it upload changes by default if I have not chosen to reinitialize a subscription? I can't seem to find any option in properties. ...more >>

i' am replication merge not adding a new column please one example Thank.. Christian Olivera ...more >>

We created a Merge replication and we chose a frequency of 'Continuous' I understand the system is now slow and we don't know whether it is due to the Merge replication. I would like to change the Merge agent frequency from 'Continuous' to '.Once evry 2 mins'. Do I change the job parameter or...more >>

Hi, Our production server used SQL Server Standard Edition with SP3, after I established Transactional replication for databases, I got error message from distribution agent as following: Executed as user: NYISE\jde. Replication-Replication Distribution Subsystem: agent CRPA-JDEE\JDEDB...more >>

I setup replication following Microsoft guidelines. during the initial setup, the distributor database was replicated to the subscriber successfully. However, nothing seems to be working now. I am not a SQL whiz by any stretch, but I can't find any alerts or obvious errors that would give me clu...more >>

Hi Guys, i am using sql server 2000(sp3) transactional replication for reporting server.4 records are missing in pulisher or in other words i found 4 additional records in a table at subscriber. i replicating only tables. btw there are no errors in the log files. any ideas? Biju...more >>

Guys Consider this scenario: SQL Server 2000 "A" is on a private network behind a firewall and can FTP files in & out SQL Server 2000 "B" is on the internet which runs an FTP server. Essentially Server B is our public facing system housing our website, while server B is our main dataprocessin...more >>

i use merge replication, when network's fail, i start synchronizing it errors: The process counld not deliver dummy update at the Subcriber. Please tell me how to resolve it. Regards TriNB...more >>