Hello... I am looking to see if it is possible to publish a subscriber... so i have the following: publisher -> distributor -> subscriber What I want is publisher -> distributor -> subscriber (now a publisher as well) -> distributor -> new subscriber Is this possible? Has anyone ha...more >>

I have a publisher that has worked for months. Now, two of the three subscriptions are getting errors: The process could not query row metadata at the subscriber. (source merge replication provider (agent): error number -217200996 General network error: check your network documentation I ...more >>

SQL 2005 Express SP1 pulling a merge replication from the command line using replmerg.exe from a SQL 2005 Std SP1 database, works great on our simple test databases. However, with the bigger more complex application we need to replicate (uses SP's, views, tables, etc.) we get the following ...more >>

We are using sql server 2005 and in our TEST environment --please note TEST-- I have set the subscription expiration interval to be 1 day. We made the mistake in the beginning of setting it to never expire and we are getting errors, performance problems etc. I am trying to test the behavio...more >>

When recovering the subscriber in transactional replication (sql 2000) is the subscriber database restored from the publisher (essentially setting it up all over) or from the backup of the subscriber?> Thanks. -- ...more >>

Hi, I would like to implement Transactional Replication in SQL Server 2005 to meet requirement for reporting functionality. The idea is to replicate data in a replica in which reporting will be perfomed. The following is additional requirement: Deletes of aged data in source datebase should n...more >>

Running SQL 2005/Win 2003 (publisher/distributor) & SQL 2000/Win 2003 (subscriber). Lat night around 6:30, 7 of my 15 subscriptions to one publication started to fail with the message below. I am not using merge anywhere, currently, though I have had a merge publication in the past that ...more >>

Can a Client Running a SQL Server 2005 Express Subscription replicate with another Client Running a SQL Server 2005 Express subscription? Or Synch with each other? Or do you still need a Std SQL Server in the backend to act as the Publisher/Distributor? If so do you still need CAL Licens...more >>

Hi All, I have a merge replication on a SQL 2000 database to a remote site. I have selected "publish all" in publication properties. Now if I a new table is created, does it automatically runs the snapshot agent and include that table in to the table schema???? Thanks in advance for the ...more >>

I am using SQL Server 2005 replication with anonymous subscriptions and web synchronization. The server is SQL 2005 Standard and the subscribers are SQL 2005 Express. Every subscriber syncs with the publisher once an hour. There are no re-publishers. The subscription databases each run a cl...more >>

Hello All - When taking a snapshot of the database, what kind of lock is put on the tables? Can users write to the tables while the snapshot is happening? Thanks, Mitch...more >>

Hi Guys, I read the microsoft article about how to handle the identity column in replication. There is sentence: " If you are using transactional replication with the immediate-updating Subscribers option, do not use the IDENTITY NOT FOR REPLICATION design." That means I can not use the IDENT...more >>

Hi all, I am trying to replicate a database (sql server 2000) to a remote site. I use merge replication and do almost continous replication. My problem is I have one application which creates atleast 6 or 7 new tables a day. Everytime it create a tables, snapshot agent restarts again and th...more >>

By subscribing to a production server, will an impact be registered on the production server? If so, can I determine how large an impact? A good example for this question would be a view that includes orderlines. Would it be possible that the publication or subscription might lock the ord...more >>

I am seeting up a transactional replication where the subscriber database has a lot of Historical data. When the distributor agent runs I get errors like Cannot Insert duplicate key in objwct... Error number 2601. Violation of UNIQUE KEY constraint ... Cannot insert duplicate key ..Error ...more >>

Hi all, I am in need of some replication advice... We have the following scenario: Publisher running SQL Server 2005 with SP1 Multiple subscribers (at the minute, 10, but there will eventually be around 30), running a mixture of SQL Server 2005 Express and SQL Server 2005. Now, I am...more >>

We have recently installed a new SQL Server 2005 box to compliment our existing SQL Server 2000. To ensure data consisitentcy we have employed replication between the two servers. We are using transactional replication, with the replication being applied at scheduled times during the day....more >>

Does SQL Server 2005 Express edition support Web based replication from one Client Subscriber using SQL Server 2005 Express and another Client using SQL Server 2005 Express? Or do you have to have to setup a Full SQL Server 2005 and configure replication first before distrubuting to the SQL S...more >>

Hi, Say in the future (2 weeks) that the database (replicated) will be upgraded and/or tables will be added/amended what is the best way to do this. For example, already one of the database tables needs to be dropped and recreated with different fields!. Can I create a schema just for this...more >>

Hi, We are running SQL 2000 with replication. We want to relocate the 'mdf' component of the user database being replicated (to another drive) and plan to use sp_detach and sp_attach procedures. Can this be done if replication is stopped? Or do I need to completely delete the replication, ...more >>

Hi to all, i set up a mergereplikation between to SQL-2000-SP4-servers, OS Win2003. When i create a publication on the distributor/publisher and try to create a pull-abo on the second server, sometimes the publication of destributer/publisher are listed under "Show publication of registere...more >>

I have a DB running under SQL 2005. I would like to enable the database for replication to offline clients (SQLExpress) and SQL Server 2005 Compact Edition. Will converting the primary keys of the database to use GUID's be sufficient to enable the replication to work property.? They are cu...more >>

When I initialized and started the snapshot agent, how can I move the table schema along with all the foreign keys? The only way I can think of is add the script for before and after the initialization. Does that mean the Replication not support repicate the foreign keys? If I have the fore...more >>

I am really stuck on this, if anyone has some insight into this problem any help would appreciated... I'll try to explain what is happening the best I can: We have a server running Windows Advanced Server 2000 (SP4) w/ SQL server 2000 (SP3a) (from now on Server A). I have a publication on this...more >>

when you implement transactional replication how many times does the inital snapshot have to run? i would assume from the word 'initial' it would be just once, but just asking to clear this up. i am also wondering because it seems like running this initial snapshot is causing the most probl...more >>

On the second screen in the wizard for configuring the distributor on SQL 2000, the correct server name has been used but the password is incorrect. There is no way to remove the server name thus no way to reenter the correct password to the distribution database. Help. -- Regards, Jamie...more >>

Top of the day all.. I'm new to replication as well as SQL in general so please excuse my ignorance.. I've run into a replication problem which is driving me nuts and any help would be appreciated.. The basics Two MS SQL 2000 Servers with SP4 installed. - Bi Directional Merge re...more >>

Hi, Again thanks to Hilary and Paul for previous questions. My merge is up and running now without any problems whatsoever.... I have two questions; 1. Where can I get a description of the different merge agent profiles and what they do?. 2. Is it possible to get the merge agent to S...more >>

Hi, I've a SQL Server in my SERVER-1 . It's possible to use my SERVER-2 with SQL Server installed in order to offer a rendundacy of SQL services? I mean to do a thins similar to what I do with Active Directory ( I've a primary dc and seconary dc ). It's possible? How can I do it? Thanks a lo...more >>

I have two identical (schema/data) databases, one on SQL 2005 the other = SQL 2000. They communicate over a VPN (T-1). Different sets of apps on both ends read and write data to their = respective subset of tables in their local database.=20 There is however an intersect of tables (2% or so) o...more >>

We currently have an SQL 2000 merge publication that will be moved to a new SQL 2005 server. Our laptops have MSDE and are currently synching via Windows XP synchronizer. Will we be able to use this for 2005 synchronization? Also, we are planning to upgrade the MSDE to SQL Express. Thanks...more >>

I have 7 tables that I want to remove the checkbox for "Enforce relationship for replication". These tables are all articles in a publication and I want them to get down to the merge synchronization laptop subscribers. On a test system, I unchecked them in EM and the changes took without any...more >>

Is it possible to replicate data from Access (2000 or 2003) to SQL Server (2000 or 2005)? ...more >>

I'm getting this error when I try to replicate The schema script '\\CVTDEESQL005\ETMSData\unc\CVTDEESQL005_ZenithSQL_L_060104_ZenithSQL_L_060104\20070120231902\tblCall_1.sch' could not be propagated to the subscriber. The step failed. I can find this row in sysMergeSchemaChange but I'm no...more >>

Any info on this error: Scenario: Replication Server: Sql Server 2005 Replication client: SQL Server Express Edition I have setup a merge publication on SQL Server 2005, with a dynamic filter (using HOST_NAME()) defined on one of the articles, also I have defined a logical record. (To be ...more >>

Hi all, What are some of the pros and cons of NOT transferring the identity column to the subscriber when using transactional replication? I am wondering if it is worth the trouble to fix this issue? Also, if I change can the identity column to "Yes (not for replication)" will this solv...more >>

Regarding log shipping on SQL Server 2000. When the transaction logs are being applied at the DR server, are users able to access the database for read only purposes and if so, what sort of reponse times do they get, ie is it unusable? ...more >>

As I am planning to implement replication at one of our client. Since I need to replicate only once per day from each server located across the globe. I figured out that Snapshot replication is best. I would like to know what kind of replication is feasible for this scenario. I need to replic...more >>

One of my clients is using an SQL Server 2000 database provided by a third party. I attempted to setup transactional replication, but this failed as a number of their tables do not have primary keys. What they are really after is simply a mirrored database for reporting purposes. So far, my po...more >>

Hello- I am seeing different numbers on the Replication Manager's Undistributed Commands tab (Number of commands in the distribution database waiting to be applied to this Subcriber:) than in the distributor's MSdistribution_status table (column UndelivCmdsInDistDB). The table says 0, the Ma...more >>

Running Win 2003 & SQL 2005 I had a problem with one of my dist agents & got backed up to the tune of 1.55 million commands in the distribution database waiting to be applied. The agent has been running for 9+ hours and the number of pending commands has not changed. Is there a setting I...more >>

SQL 2005 SP1 & Win 2003 on both ends..... I am getting this error in my log. The dist agent will not complete. I have stopped/started the SQL Server Agents on both boxes ot no avail. HELP!!!! Larry..... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Date 1/23/2007 10:19:00 ...more >>

Hi, I'm using merge replication to replicate the Customers, Orders, OrderDetails and Stock tables from server A to server B. Everythings works as expected except the stockage level for a product. Think about this scenario: 1) Initially the stockage level of product 1 is 20 units. 2) Se...more >>

Does anyone know if the Log Shipping can be re-initialized just like Database Replication OR can I just disable the Log Shipping temporarily then Re-enable it later OR I have to start over the whole setup process again? Thanks Ed ...more >>

SQL 2005 sp1 merge replication. 1 publisher/distributor. 20 SQL Express(SP1) subscriptions. Working OK since we set up about 7 weeks ago, today we recieved the following error when attempting an update on the publisher. The table is bidirectional, auto identity range mgmt, column level track...more >>

Hi, I am having a problem setting up log shipping for a large, 45GB, database. I had log shipping working for this database. Then one evening it failed because it could not apply a log file. I cleaned up by removing log shipping from the maintenance plan, deleting the plans, jobs, suspect des...more >>

hi, i have one server that's same publisher and distributor, i use transactional replication with updatable subcribers (four subscribers), all servers use SQL Server 2005 Standart. For two times i have the same situation. With no explanation the subscritions reinitialize, but more interest, ...more >>

OUr distribution agents keep shutting down due to ODBC timing-out. I think the batch size is too large (default) and that long-running queries block the stored procs. Any comments on how to minmize these time-outs? Thanks! Hiss!!...more >>

Hi to all. I am trying to start replication process and I got this message: ODBCBCP driver error. I look for version number and publisher and subscriber are different. What should I do to make both environments equal? Regards, José...more >>

Hi everyone, I have a server and several clients. I plan to make a mirror from server's database. Can you all please help me how to do it step by step? Thanks, Nassa ...more >>