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