Hi, I wanna replicate two SQL Server 2000 DB, On is in my Company behind a DSL Router, the other is in a Machine on somewhere which I purchase as a Hosting package.. Configuration of Local SQL Server is already Done by Me and Publication is Created, I chose Snapshot one... The problem is...more >>

We are using transactional replication with concurrent snapshots. Publisher and Distributor are on separate machines. Distributor and Subscriber are the same sql server. Initially, we didn't run into problems. But after adding more publications and subscribers we've seem to run into some th...more >>

I have a separate server that is used as the distributor. We have our production replication using a db called DistributorProd on this server (this was built several weeks ago). I was doing some testing, so I created a second db called DistributorTest on this server. After I was done testing, I ...more >>

Hi Guys, I have been analysing our merge replication for the past 2 months with ongoing performance issues. I have been in constant talks with Microsoft regarding performance and bug issues within merge replication and have had numerous fixes and hot fixes set to me. We have found multiple ...more >>

Hi there, I have four databases set up with merge replication. I have a filter that says only replicate a record if its timestamp is greater than one day ago (I don't care about any data older than one day). If I now go into Database #1 and delete a record that is older than one day, I do ...more >>

Hi, I am very new to replication . Can anybody give some initial steps to do it. regards Ar ...more >>

Greetings.... I have a tape drive that my data base it backed up to. I'm running SQL Server 7 and I backup the entire MSSQL7 folder. I needed to restore some data in the database. The file was going to restore was my_database_name.mdf. Is that the actual database file, and if not, wha...more >>

Hi there. We have merge replication arross internet at the same domain. I got error message as: The process could not query row metadata at the 'Subscriber'. (Source: Merge Replication Provider (Agent); Error number: -2147200996 --------------------------------------------------------------...more >>

hi all, I have a single sql server, and two databases with similar table names and structures for some 10-15 tables. I want replicate the data from one db to another to keep them in sync. Can I do this using replication ? Is replication possible between two db's of a single server ? ...more >>

How many articles can take part in merge replication? I need to replicate about 200 tables. From them 25 are common for all my subscribers and do not need to be filtered. Other I plan to filter with static filters. Is there benefit to allocate this 25 common tables in separate publication or...more >>

I am new to replication. I need to find out information about the following Replication model: central subscriber SQL 2000/ multiply publishers MSDE . If anybody knows it is possible and what to read. Thanks a lot. ...more >>

I have a SQL server with 90 databases (with avg of 30 tables in each) , each needs to be replicated (Transaction immediate) The Distrubution databse is on this server. I have been having problems with some of the database failing to replicate, and I was wondering if Log shipping between ...more >>

Hi all Gurus I am new to replication, can any one guide me for some links from where I can learn step by step about replication. -- Thanking You Amish M Shah IntraAction Software ...more >>

So, let me relate to my earlier post in this group about merge replication and foreign keys. As I've mentioned, I have one publication that pushes 'customers' table to the subscribers. I have another publication that pushes 'invoices' and 'invoices_det' tables to the subscribers. In table i...more >>

I try to restore a set of replicas where the main server has been stolen. Fortunately I have the databases at another server but when i try to push a merge replication to a new main server i can not create a merge publication beacuse the database has merge subscriptions that are anonymous or t...more >>

Hi All, I select the wrong database to do merge replication. Trying to delete the replication I delete the suscription and the publication but still replication folder in my database and all my tables have the extra columns. How can I delete the replication from my database so I can start all ...more >>

Hi everybody, I´m a beginner in Replication, and I need to find out information about Replication. If anybody knows "Replications for Dummies or Beginners", let me know. Thanks a lot. Richard_SQL...more >>

I am replication on a SQL Server 2000 env on Windows Server 2003. I randomly get an access violation error stating "Syntax error or access violation" ODBC error 37000. After further investigation using sp_browsereplcmds I see that a blank field in the db is sending the following repeated abo...more >>

In the .net compact framework, there is a method called ReinitializeSubscription(). There is a boolean parameter with this method where you can choose to upload the data from sql server ce to sql server 2000 is it is set to true. After the upload sql server 2000 provides a snapshot to the ...more >>

Hi all, I would be grateful if you all could help. I have one server acting as publisher and distributor in one data center and the other one center acting as subscriber in another data center. I would like to perform replication between these two computers. In order to perfo...more >>

Sorry, this is a long winded post I know. But all help is appreciated as me and my managers need to explain all this to our CEO on Monday. sql2k sp3 Transactional, non immediate Updating, continuous, no Transformations Replication. This last Tuesday morning a report against was run agains...more >>

I have merge replication set up for more than 2 years now, I'm more than happy with it. I have several dozens of publications, a lot of subscribers, totalny 7 databases being replicated (for various branches, all on one central publisher). The bussines i'm serving is trade-import-export kind ...more >>

I have transaction replication setup between two servers running SQL Server 2000, standard edition. On the publication table article properties, I have it set to 'Automatically assign and maintain unique identity ranges for each subscription.' When I attempt to pull the subscription and it s...more >>

I have transaction replication setup between two servers running SQL Server 2000 (standard edition). The subscriber is an immediate updating subscriber. I am having an issue when I try to update two tables from the subscriber. When I attempt to perform an update on either table, I rece...more >>

Hi, I have a strange problem here: transactional replication is running between two servers (sql2K, sp3). At one end of the replication, Log Reader agent is failing with the following error message: "The process could not execute 'sp_MSadd_repl_commands27hp' on 'server name'" Error deta...more >>

We had some data become corrupt on our publisher and have to do a database restore. Am I correct in thinking that after the restore I can just click 'reinitialize all subscriptions" and the snapshot and transactional replication will clear out the old data and fill with the new data again at ...more >>

Hi. I would like to apply the objects' permissions after to apply an snapshot. To do it, I need a script file, with the grant commands to apply that permissions. Could I get that script just before applying the snapshot with any t-sql command to generate and save the script file with these ...more >>

we are looking to doing a transactional replication of a database of 12 gig between instances of sql 2000 on the same server. We want to do this so we can have a read database and a write database. On other setups we have had a write database and a read database different servers. We have ...more >>

Hi, Does anyone can tell that our production primary site need perform server power down, and I have the databases transactional replication with push setup on primary site? The secondary site will run all the time. Before, primary site perform the power down, do I need stop the Log Reader ...more >>

I have a table Customers on a SQL Server. I want to synchronise this table with the SQL Server Ce running on a pocket pc. This works fine. When I try to synchronise with 2 pocket pc's, I've got the problem that the pocket pc's overwrite eachothers data on the SQL Server. This is because th...more >>

I'm considering using merge replication and I want the subscriber user to be able to compare multiple conflicts (a number of columns across multiple rows), resolve them and then update. I've already written this in Access and replicate the data manually using recordsets highlighting conflicts ...more >>

I'm receiving an error when I try to apply the initial snapshot to several pull suscribers in a merge publication. I modified one of the views in the publication, to reference other views. The merge agent, is trying to create the dependent view, before it has created the referenced view. Th...more >>

Under the Subscription Deactivation and Expiration topic in BOL, there are 2 statements made that seem to be confusing A) The default for maximum transaction retention period is 72 hours for transactional replication B) The publication retention period for subscriptions is specified on the ...more >>

Need to increase my subscription that will expire soon to more than 72 hrs. Is it as simple as changing the value in the publication properties ? One of my subscriptions is in an inactive state for more than 40 hrs and dont want it to expire in 72.. Please advice.. I wish not to reinitialize . Th...more >>

1)Have Transactional replication and wanted to know what was the maximum transaction retention property for distribution database is 2Also i was looking at the properties and it says that the subscription could expire or get dropped if not synchronised within 72 hours. So my question here is u...more >>

Hello: When Need I to use reinitialize in my subscription with merge replication? I Use a very complex dinamic filters. Thanks a lot Wend ...more >>

Hi all, I am wondering if I can expect are any major problems with the following scenario: Server 1: US SQL 2K Server on an US Windows XPSP2. Publisher. Client 1: US MSDE (rel. A) on a US Windows XPSP2. Subscriber. These two won't be a problem but the following might be: The second cl...more >>

Hi Freinds, SQL 2000 I have an transactional replication. I have to update table structures. I know I can reinitialize the whole subscription to have the update on subscriber. is there any way to initialize only specific alticles to regenerated on next snapshot? Thanks, Pat ...more >>

This was originally posted on 11/24. Hilary drew a blank. I am reposting in the hopes someone else will have some insight. ~~~~~~~~~~~~~~~~~~~~~~ SQL 2k & Win 2k I have a server(S1) that has a trans. publication of 4 tables. I have another server (S2) that has a subscription to the publi...more >>

In Enterprise Manager (EM), if you go to: [Replication Monitor -> Agents -> Merge Agents] you'll see a list of Merge Agents to the right. I'd like to be able to select one of the items, right-click, and select "Agent Properties". When I do this, I get a dialog box that appears. The title of...more >>

Hi All, I have tested transactional replication on test server .It's working fine.On my live server , huge data is getting inserted every day , around 2000 records per day . update happens around 200 per day . I have a doubt about the transaction log getting increased . I have tested the same...more >>

Hello, I have a server that lists several Subscriptions (under Replication -> Subscriptions in Enterprise Manager) that are no longer in use. Two of them reference a server that was decomissioned over a year ago which no longer exists. Why do these old subscriptions still show up in the Subs...more >>

We have an application that has many databases (100+). We are in the process of adding replication to these databases. Can we expect that we will be able to scale to 100s of databases with replication enabled? Can we expect to have 500 or a 1000 databases with replication? Thanks...more >>

Let's say I have a database with three tables. One for customers, and two for the invoices. Customers have cust_id field, wich is 'surogate' key, it contains the org_id where the customer was created. That table should be in merge replication because I need to be able to add data and make changes...more >>

Hello, I am trying to execute a Select statement from Oracle server and insert into a table that is used as an article into merge replication. The query is as follows Insert Into Test (testid, testname) Select testid, testname FROM OracleServer.CRM.TestTable Where testid = 1 This stat...more >>

Hi! A few days ago the number of replication commands grew up to ~6 000 000. A normal number used to be ~20 000. The replication agents are working fine. The data on subscribers are valid. I suspect that the history clean up agents don't remove old commands, although their status shows su...more >>

I am trying to create a PULL subscription from EM between two SQL 2000 servers on the same network. At the end of the wizard I get the following error message. ERROR 15004: Name cannot be NULL I cannot find any detail information of what is the cuase of this error any possible resolutio...more >>

I'm starting to develop quite a list of conflict tables in my Publisher database (merge repl). I've not been down this road before, but all I need is pointed in the right direction on how to resolve these. ...more >>

Hi everyone, I have 2 publishers and 1 Subscriber. I'd like to implement a one-way replication. Each table has a primary key but most of the new records inserted in the publisher DBs are identical (only a few records are "unique" to each DB). 1) Should I use Transactional or Merge Replica...more >>

We have one publisher push the same set of data to 3 subscribers. Problem is one subscriber went down today . How can I enable replication for just this subscriber without pushing the data all over again for the other 2 that are running fine now ? Thanks ...more >>

Greetings, Here is the scenario: Server A is Prod, Server B is reporting or history Server A does Transactional replication to Server B. Server A gets records purged at the given point of retention. So as you can tell Server B will have much more data than Server A. Today, I get the dreaded c...more >>

I am trying to backup a log file with truncate only and I am getting an error. Is there a way I can remedy this without changing the log filename?...more >>

I have a publication with 5 tables in it. I need to drop one of them without affecting the other 4. Is this possible? thanks, -comb...more >>

Hi All, I,m trying to pull a suscription for the first time so I create the database when I create the suscription but I'm getting this error. could not be propagated to the subscriber. (Source: Merge Replication Provider (Agent); Error number: -2147201001) ----------------------------------...more >>

I have Transaction, non Immediate Updating replication set up between two boxes on one databas each. For whatever reason, I have more than 1 distribution agent job? Of course only one is runnning. However, I'm trying to write an sp that will stop the replication jobs and it's causing problems to...more >>

Is there an easy way to take apart replication when a server has been renamed. The sever in question was a subscriber to one publication and the publisher of another. Is there an easy way to drop the relvant subscriptions publications now that this server has been renamed. As I presume sql doe...more >>

I have setup Merge Replication between Local and remote Servers.I am getting the following error "The merge Process could not perform retention- based meta data cleanup".What is the reason behind this.Shall i Change the schedule of the merge agent job to sunday so that it wont run on produc...more >>

Trying to merge replicate a database, but it is very slow. At the subscriber it inform: "Uploading data changes to the Publisher" and then stuck for very long time. After that it informs several lines of: "Processing article 'TableName'" and fail with "General network error…". Publisher, dist...more >>