Hi All, I'm running merge replication. I want to add some keys for existing fields in a replicated table (composite keys). Is it possible? How to do that? Thanks...more >>

Hi Please direct me to the correct news group if this is the wrong one. I get the following message when I restore my database from a backup file "the media family is incorrectly formed". It may be worth pointing out that the file was backed up from a different server. Thank you in adva...more >>

Can I use SQL Server’s inbuilt replication to replicate between a SQL Server database and a number of MS Access 97, 2000 and 2002 databases over the internet? I need to replicate in both directions and Jet 4.0 is installed on the client computers. Are there any solutions that will do this ...more >>

Hi, I restored a replicated database backup(sql 7) to another sql 2000 with recovery mode 'full'. The sql 2000 server dose not have any replication setup, but after the restore, the database transaction can not be truncated any more and keep growing. **Ran dump tran 'dbname' with trunca...more >>

In the virtual directory set-up for the Snapshot folder location, I am typing in \\C16221(my computer name)\20041016174338(snapshot folder name) not only this i even tried so many other combinations of location format found on the google groups, but none of them works..it gives an error call...more >>

I have an app that has this design: MasterDB contains all the templates used by the app and a record of all DealDB's created, DealDb contains just the data, imported from various sources. A new DealDB is created for every new "deal". The app works fine in the office, now I want to extend it ...more >>

Hi Paul, To switch back roles from the new primary to old primary, why you need to rename the server, use sp_dropserver, sp_addserver and restart the services? Thanks for your help....more >>

MSSQL Server 2000 SP3a -> MSSQL Server 2000 SP3a Transactional Replication Push subscriptions Transactional replication has been performing well for years between two servers. I added a new publication to handle some other tables. Both publications had push subscriptions to our Production a...more >>

I am trying to remove a table from a Publication because I want to modify it. I am going to the Articles tab in the Publication Properties dialog. However, the checkbox is disabled, probably because the snapshot has run. How can I modify the table or remove it from the Publication so that i...more >>

Hi I am running a SQL 2000 database on Windows 2000 Server and am trying to use a transactional publication to push to an Oracle 8i subscriber. When I push the subscription, I get the following message on the distribution agent: The process could not connect to Subscriber <ODBC data source ...more >>

I would like to clear some confusion that I have related to EMCs SRDF solution. I understand this solution to be an EMC proprietary disk synchronization/replication hardware technology. I have an environment that will include 2 sites connected via high speed, redundant WAN links. Each si...more >>

I decide to check with the forum because I haven't got any lucky result. Here is the transactional replication between two SQL 2000 standard edition + sp3 servers I inherited a few month ago. On the subscriber, when I pushed a new subcription there was an error "Cannot insert duplicate key row ...more >>

I would like to add a table to an existing merge replication. The DB is approximately 11GB in size. When I proceed through the steps to add the table using Enterprise Manager, SQL Server 2000 responds as follows: "After adding a new merge article, you must generate a new snapshot before c...more >>

Hi Guys, I don't know if you can help, I have a couple of issue with Merge replication running on SQL Server 2000 SP3a. I install merge replication and build all the snapshot for the pull subscriptions and create the subscriptions running on the local machines (MSDE 2000). This particular i...more >>

Posted a question in DTS NG and was directed to this NG to ask for Hilary Cotter or Paul Ibison. I have posted below the reply and then original question. Any suggestions would be greatly appreciated. Reply <!-- You could use replication + DTS (Ask on the replication NG - Hilary Cotter or...more >>

I have a publication that is being pulled and when I execute a UPDATE command example: UPDATE Oils SET Description = 'This is a description' The SQL Query Analyzer completes the command successfully. I am receiving confirmation that more than 30,0000 rows have been updated when I run this co...more >>

I have a publication that is being pulled and when I execute a UPDATE command example: UPDATE Oils SET Description = 'This is a description' The SQL Query Analyzer completes the command successfully. I am receiving confirmation that more than 30,0000 rows have been updated when I run this co...more >>

Replication appears to be reading rolled back transactions. We are seeing rows on our subscriber that do not exist on our publisher. The data on the publisher is what is expected, the rolled back rows appearing on the subscriber obviously are not. Here's the basic structure of my two stor...more >>

Hello, I have currently problems shrinking transaction log files in my ms-sql = server 2000 DB. The problems started after moving to new hardware, so = there was a fresh install of ms sql2k and the db's were created from = backups taken from the old system. The usual steps : backup log to...more >>

Dear friends I have following problem in replication kindly suggest what can be the problem. Last Command: create table #belong_agent_-2049795750 (tablenick int NOT NULL, rowguid uniqueidentifier NOT NULL,generation int NULL, lineage varbinary(255) NULL, colv varbinary(2048) NULL) E...more >>

Hope someone can help with this. I have one database where all the tables were joined by a auto incrementing column. Now we are trying to see if we can move to having multiple databases (replication) across different offices which has the same tables. Each office would merge in their re...more >>

I assume this is the correct spot for a log shipping question. Pardon if it's not. I've set up a log shipping pair (first time) and everything 'appears' to be running fine, but I have a question about fail over. In my research I have found that, in order to bring the secondary up as the ...more >>

Can anyone tell me the names of some non-Microsoft Replication providers? I have found a company called Peer Direct, but would like to see what other alternatives exist for replication. Thanks in advance Ron L ...more >>

I have full backup of database at 13:00 and another full backup at 17:00. I've made backup of transaction log at 17:05 When I try to restore database to state at 15:10 (point in time) , the dialogue in Enterprise Manager says that only time after 17:05 is valid. It seems to me that I'v...more >>

i was doing replication on SQL 7, both my pulisher and subscriber was SQL 7 and the replicatoin was happening without any problem.Then i upgraded it to SQL 2000 and restore the backup which was taken on SQL7. After that when i am starting my agent then it is giving thie error "ANOTHER SNAPSH...more >>

Hi, I am trying to configure my serwer (local computer) as a distributor and publisher to see how it works. I have created sample database with one table and few filelds. One of them is unique primary key. During Configuring and Selecting Distributor or Creating Publication I get an error:...more >>

Hello, I am new with MSSQL 2000, and I need help to design a replication topology. I have 5 MSSQL 2000 server running on W2K3, server A, B , C, D, and E. These servers must have the same database at all time using merge replication. All these servers also publish data. Data changes in each o...more >>

We have several SQL Server 2000 databases servers. We would like to do snapshot replication to a central server. The central server would be sp3a and most of the servers are sp3a. We still have a couple of machines at sp2 and will be upgrading shortly.. My question is: Can snapshot repl...more >>

I have a general question. I want to push data from MSDE to SQL Server 2000. The pushed data is to end up in a 'staging' database on SQL Server. As part of this process I want to run a stored procedure against the staged data to update the production database (on the same SQL Server). I then...more >>

We have 1 production SQL server (W2K3 Enterprise, SQL2000 Enterprise) that has a database maintenance plan to send a backup, and transaction files to a file server for tape backup every night. I am going to bring up a backup SQL server for Log shipping. Will these 2 things conflict if they ...more >>

Hello, I have a table JobDescription with the columns: JobId Email StartTime EndTime Priority etc. I want the Filter in that way that only the rows of the JobDescription of a certain Email Adress will be synchronized. Can anybody tell me how this work? thx mathon...more >>

We have serveral office of which have there own SQL Databases running in MSDE and SQL Server Enterprise running at the Corp HQ. At HQ there are tables for say Office 1 (Ofc1) in a central database. The central database has a shema for each office in the central database ie ofc1.tbl_contacts, o...more >>

We are trying to set up replication of a large (over 200GB) database, attempting to break the transactional processing and reporting apart, obviously replicating from the processing database. (This is a temporary fix until we can implement our data warehouse.) There are approximately 70 ta...more >>

I've got several secondary servers setup against my production server, and working fine. However, one is across a t-1, and the file copying can really effect latency across this link. I've been searching far an wide for a "replicator" that has a client server component, that can do streami...more >>

We have transactional replication with three boxes - pub, dist, subscriber. Application code does begin tran/inserts/rollback and our prod box rolls back as expected but somehow the transaction ends up on the subscriber. The application group is suspicious of a patch at the OS but hardware ...more >>

Paul or anyone do you have any resources on how one could document a replication strategy. Thank you, Abdul Rauf...more >>

We currently do transactional replication between sql 7.0 and Oracle 8i. We're planning to upgrade to Sql 2000 64 bit however Microsoft does not provide a 64-bit ODBC driver to Oracle. Oracle does provide a 64-bit ODBC driver. Has anyone used Oracle's 64-bit driver for replication or know ...more >>

I have seen several people asking about this but not too many replies that did not include dropping the replication. I am using a combination of the sp_repldropcolumn and sp_repladdcolumn to accomplish modifying a column without having to drop the replication or reinitialize the subscribers. I...more >>

I set up merge replication between 2 sql servers using EM. I can update the publisher and see the change on the subscriber but cannot see the changes on the publisher if I update the subscriber. I don't want to use snapshot or transactional replication but am wondering do I need to set up t...more >>

Hi Group, I just started at a company and am trying to come up with a solution to streamline the datawarehouse. The problem is, we have two databases. Database1 (548 tables) is generated from user input and we cannot control the schema. Database2 (40 tables) is a staging DB that optimally...more >>

Hello, I am trying to connect a remote sql box to another sql box using pull subscription. I have the publisher registered in EM. When I try and create a pull subscription it cannot find the publication unless anonymous subscribers is on. Did I miss setting a password somewhere? Thanks ...more >>

I need to update table to add more columns, this table was involved in merge replication, but it was long ago. The replication was deleted ( i think successfuly ). There is no information about this table in sysmergearticles. In sysmergepublications publicaton is deleted. But on table replica...more >>

I need to establish procedure for subscriber (Transactional replication - data only) to assume role of primary-server in the case of primary server failure. We have basically decided to user replication method to have warm stand-by server (log ship was not an option because of different versio...more >>

Hoping someone can help. What merge system table/s will give me the current status of my merge agent i.e. the Replication Monitor window in Enterprise Manager displays a status of 'suceeded' etc etc - where can I source this field from within the Replication System tables? Any help appre...more >>

Does anyone know of a SQL Compare tool that allows for the disabling of Replication when doing database compares? I have a large number of identical merge replicated databases and am using the Redgate SQL Compare tool. It is a great tool but always identifies every table as a diff because o...more >>

I have two MSDE servers on different machines and am trying to set up merge replication between the two. When the merge agent runs on the publisher, it indicates that the "process could not connect to the Subscriber" (SQL Server does not exist or access denied). I'm not sure if matters, ...more >>

Is it ready?...more >>

Does anybody know, is it possible to use JOIN in transactional replication filter clause. How can I create filter clause for e.g table1 based on table2 rows. More details: I'm trying to create bidirectional partitioned transactional replication. I'vo got one main server, which contains all...more >>

Hello all, I have a merge publication on one end of a slow WAN link and a subscription to said publication on the other end of the aforementioned slow WAN link. Recently, the link decided to take a vacation for a week or two and was (for all intents and purposes) inoperable. Upon finally fixin...more >>

We currently do transactional replication between sql 7.0 and Oracle 8i. We're planning to upgrade to Sql 2000 64 bit however Microsoft does not provide a 64-bit ODBC driver to Oracle. Does anyone know who provides a 64-bit ODBC driver for Oracle 8i that we can use for replication from SQL...more >>