Hi Guys, i am planning to implement logshipping in sql 2000 which is already a pulisher for transactional replication. i am planning to take transaction log backup in the interval of 1(one) minute. if network connection broken will it affect restoring at desination server? can i make the...more >>

Version: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) Problem: Merge replication snapshot agent not finishing. Always fails with "agent is suspect ...more >>

I get warnings when I run the scripted exec sp_addmergearticle @publication = N'pubTempDB', @article = N'TableTemp', @source_owner = N'dbo', @source_object = N'TableTemp', @type = N'table', @description = null, @column_tracking = N'true', @pre_creation_cmd = N'none', @creation_script = null, @schem...more >>

I have a merge publication (dynamically filtered). Subscriptions are all anonymous (all run at the subscriber) and run continuously. What effect does the publication option @max_concurrent_merge have on a replication topology such as this? Also known as the "Publication Properties | Subscripti...more >>

I am running SQL 2000 (using replication) & Win 2000. We are getting a new production sever and would like to know the best practice for moving all the SQL data from the Old Server to the New Server. There are a few questions the concern me. - Will I have to setup replication on the ...more >>

I want to know how to obtain an encrypted communication between two SQL Servers using Replication. I saw that using SSL is posible to grant secure communication between client an server, but how can i encrypt communication between two servers?...more >>

Hi All, I have got project server 2003 installed at both forest DC and child DC, what if i want to replicate both the datbases with each other. And which type of replication most importantly...more >>

Hi I have setup snapshot replication in one of my sql database. The article which i publish, has full text index enabled in the subscription db. So when the initial snap shot is applied, i get a error message saying "cannot drop index PK_<<table name>> because it enforces full text key. It rea...more >>

We are trying to setup a somewhat warm standby server using SQL Server 2000 Standard and one way transactional replication. (The powers to be won't spring for the Enterprise edition for the log shipping functionality) If I have the wizards do everything it works great. The problem is that if we ev...more >>

Hi, I'm making a transactional replication. I get the following error: Could not bulk insert. Bulk data stream was incorrectly specified as sorted. (Source: SQL4 (Data source); Error number: 4819) ---------------------------------------------------------------------------- ----------------...more >>

We currently have multiple tables being replicated using merge snapshot. In the majority of cases the whole table is required or a row filter is applied based on a value in that table. We have two sets of identical databases, except for their data, that replicate their data from a backend data...more >>

We have a merge replication database with a publisher server and a distribution server. We made and publication with dynamic filters. We are using a pull suscriptor wich was installed with a backup from the publisher database First time we made it works we had no errors and no conflicts. However,...more >>

At the moment I have a publication with some tables(not all tables in the db). But the tables inside the publications contains references to foreign keys to tables outside of the publication. How do I create new subscription disregarding the Foreign keys constraint to tables outside of the publi...more >>

Hi, sql server 7 i have a replication job going on for one particular table from one server to another now i have added two new columns in source and replication works fine. once i add these two new columns in destination the replication is failing. i went to properties of the publis...more >>

Hi There, I would like to filter first or latest 100 row while performing the publication for merge replication. Is there any information how i can do this in the case when table does not exist date fiels. Thanks for help. Indra. *** Sent via Developersdex http://www.developersdex....more >>

Hi Can someone please tell me, when i setup a publication for transaction replication (push only), sometimes it says: "SQL Server requires that all articles in a publication allowing updatable subscriptions contain a uniqueidentifier column named 'MSrepl_tran_version' used for tracking...more >>

Hi there, we are using merge replication on sql2000.We are using partial replicas. We have different identity value set for each of our remote subscirbers. all tables are fine they all have the key value as what they should have except one table. this particular table on all our servers i...more >>

Hi, I have enterprise level replication running both snapshot and transactional. Its been identified that no of records in tables participating in transactional are more at subscriber when compared to Publisher/Distributor. But there are no errors at publisher level stating the mismatc...more >>

I have just setup log shipping, but have a problem with the monitor server. The log backups from the primary server to the secondary server are running fine, but when I check the monitor server properties. It's says it's not updating the last backups file, last file copied and the last file loaded ...more >>

hello, I tried to established a replcation between SQL Server 2000 and SQL Server CE. The application is witten in eVB 3.0. I have an object : Set ce = CreateObject("SSCE.Replication.1.0"). the short formof the source is like : ce.AddSubscription CREATE_DATABASE ... ' Perform the first...more >>

We were rebuilding our replication when our application was online. Since we were online, we had enabled the parameter "Do not lock tables during snapshot generation" so that users would not be blocked. But, we started seeing a lot of deadlocks in our application which we never had before. So ...more >>

Any ideas! I create a publication of one table with an identity range of 10 I create a subscription for this table with an identity range of 10 I use a new range percentage value of 50 At the publisher I can insert rows 1-19 (should be 1-5 ?) At the subscriber I c...more >>

Hello All, I just set up Log shipping and it appears to be working fine however I am unsure of a few things. My current set up is this: Log Shipping runs from 7:00A.M to 7:00 P.M Mon - Fri, Each night on the Primary server, I run a complete Backup of the DB at 9:00p.m. Now, if I were to resto...more >>

Is there a command I can execute through SQL Query Analyzer that will mark a subscription for reinitialization? Thanks Brad ...more >>

I have SQL Server 2000 Enterprise Manager with SP3A and transacional replication. This operating system is Windows 2000 Advanced Server. The replication is only to one server at the same location. When SQL Server 2000 has deadlocks and the CPU is greater than 85% for 5 - 7 minutes t...more >>

I have a snapshot publication. When I defined the article on the table Quote, I selected "Delete datain the existing table that matches the row filter...." I also checked "Include declared referential integrity" When Engerprise manger generated the script for the publication it did not include t...more >>

We somehow orphaned a snapshot agent. Enterprise Manager shows an agent but no publisher or subscriber. I manually removed the job hoping the agent would disappear from EM but it didn't. We know it's harmless, but the little red X in replication monitor is annoying and since it's a prod...more >>

We somehow orphaned a snapshot agent. Enterprise Manager shows an agent but no publisher or subscriber. I manually removed the job hoping the agent would disappear from EM but it didn't. We know it's harmless, but the little red X in replication monitor is annoying and since it's a prod...more >>

I'm trying to re-enable replication back on the server, it used to work, then we disable it for a while, then I.T. decided to change the server name, NOW, it encounters a bunch of problems when trying to configure replication... there are a bunch of stored procedures are missing from teh MASTER da...more >>

hello, I've a problem when creating a transactional replication on an SQL server (Version 8.0). The name of some fields unfortunately is "Key" and so i get an error when i try to create a new article based on these objects. The error: Error 156: Incorrect syntax near the keyword 'Key'. Is ...more >>

I've got merge replication between a hub site and 22 remote locations. All was going well until last monday when all jobs began to fail. Our DBA ran the cleanupmetadata routine this appeared to allow replication to begin again however our servers are all now extremely slow accessing data and even...more >>

Hi, So far I used merge ActiveX control to start and monitor pull merge subscription within C# client application. Due to fact that some subscriber machines are rather slow and publication is relatively complex (lots of join filters etc.), I want to offload processing to distributor. Some subs...more >>

I have SQL Server 2000 transactional replication running on several development servers. I would like to collect transactional replication performance data so that I can analyze replication data. Are there tools within SQL Se rver 2000 that can help me complete this task? Third party...more >>

Hello... Merge Replication was working fine on our Windows 2000 server. Since we changed to Windows 2003, we only get the error about the "Reconciler has failed [,,,,,]" error message. My attempts to get the sqlCe logging to be more verbose do not work. I reset the value in the regis...more >>

I have 3 production machines which are replicated to a dr site, all machines are using a central distributor machine. I have created a separate distributor database for each system. My problem is that one of my systems will not replicate I am doing snapshot and transactional, it just keeps timin...more >>

Hello, I am trying to setup replication for a database and I get the following error. This is the content database of WSS. I noticed that the collation was set for: Latin1_General_CI_AS_KS_WS which is diffent from our normal collation setting SQL_Latin1_General_CP1_CI_AS, however I created...more >>

How I make to generate reports of the replicated data ? The report must have the format : origin,destination,datetime,table name, and records of the table. Thanks ...more >>

Hi group. I am having problems to configure my SQL Server as Publisher. The following message appears: "SQL Server Enterprise Manager could not configure "MyServer" as the distributor for "MyServer". Error 14114: '(null) is not configured as a Distributor' I have a SQL Server 2000 Personal E...more >>

I had replication on a SQL 7 box and then removed it. I think it was not properly removed as while doing an upgrade of an application that uses the database I got a message saying - [Microsoft][ODBC SQL server Driver][SQL Server] length of text,ntext,image (179948) to be replicated exceeds confi...more >>

Hi everybody... I need to implement a publication but I got the next message when I start the assistant: "SQL Server Agent on 'USER07' currently uses the system account, which causes replication between servers to fail. In the following dialog box, specify another account for the Service startu...more >>

I restored a a dB and for what ever resaon, it is a warm standby that is replicated. I am attempting to delete the dB via EP, but.... I cannot delete it because it is being used for replication. I cannot remove replication because it is read-only. I cannot remove the read-only flag b...more >>

I am using Replication ActiveX Controls for replication. I am getting this problem only when i try thru internet.It is working well in intranet. If anybody knows the reason please help me....more >>

I have what (in my mind) is a simple request but am currently lost in a sea of different terminologies and scenarios.... Not sure if this is the right ng but can anyone point me at some very basic starting points to read ? Situation is this :- We have a single domain, single site LAN. ...more >>

Hi, We have publisher and remote distributor with lot of transactional and merge publications. (SQL2K SP3) Recently we migrated our publisher to a new machine. Today I renamed my old publisher server and tried to disable subscribers on it (because everything works on a new publisher alrea...more >>

Hello I have a SQL Server called 'D1' that has 'DEV1' as it's Distributor. 'D1' has two Publications involved in Transactional Replication (both using 'DEV1' as the Distributor). I need to set up a third publication on 'D1'. My goal is to use a different Distributor for the Publication on 'D1' ...more >>

Hi group, I want to know if the system tables added by replication (MS_%) are automatically purged in any way? Or is my task to clean them regularly? If the former is true, what is the recommended cleanup procedure? Thanks, Renato ...more >>

Publisher /distributor - same server SQL Server 7.0 SP 4 Subscriber - Oracle 9.2.0.3.0 After configuring Oracle subscriber whether as a linked server or a system DSN, I run the distribution agent and get the following error message: "Distributor must be running in per seat (named user) lice...more >>

I have merge replication set up on Server A with the distributor also on Server A. I want to set up transactional replication on this same Server A, but with the subscribing Server B set up as the distributor. Is this possible? I've tried creating a new publication, but it won't give me the optio...more >>

I have SQL Server 2000 transactional replication databases that timeout with errors listed below. The databases were replication for two days without a problem and I received the errors listed below. Please help me resolve these errors. Thank You, Mike Errors from Distribut...more >>

Hi there, I have access adp file as a front end and MSDE (sql) and a back end in our client's labtop and sql 2000 server with database in main office. I have wrtten script on the front end to synchronize and to create pull subscribtion. But how i know whether synchronization has completed or ...more >>

Hello... Our replication does not work after we changed the server's OS from Windows 2000 server to Windows 2003. Is this a known issue? I have set up both Sql Server and the Sql Agent to use a domain account. I have even added this account to my Administrator group and I still keep ...more >>

Dear Friends I am trying to validate the data for the merge replication with only one subscriber and find the following errors: Article 'Purchanse' failed data validation (rowcount only). Article 'Purchanse' failed data validation (rowcount only). (Source: Merge Process (Agent); ...more >>

Dear Friends I have a table Purchase and Purchase1 ( Copy of the Table Purchase ) All my users should work in Purchase but due to the problem i have asked them to work in Purchans1 and now there is a problem that some data is in Purchase and some updated data is in Purchase1. please su...more >>

Dear Friends I am facing a strange problem. I am using the merge replication from two offices for my database and the current changes are showing perfectly on both the end but for last two days change the database if diffrent some information is in the Site one database which is updated ...more >>