How can i check if my distribution agent has the independent agent option enabled during transactional replication ? ...more >>

Can someone point me to where I can find the psot SP3a Rollup? I've been digging forit and can't find it...from what I've seen on here, it addresses a couple of issues with replication I may be encountering. Thanks!...more >>

Hi, I'd like to duplicate a database in the same sql server but with a different name...I will use the duplicated one for testing purpose only how could I do that? Thanks Ilann ...more >>

I would like some feedback on which publication type is best for my scenario. I am trying to decide between a Snapshot publication and Transactional publication. I have about 3 tables I am going to replicate in one publication. Each has approx 6 million rows. A set of updates are done night...more >>

I have 2 databases on different location can i sync one database with data from the other using logshipping by copying the log file from one location to the other? There's no network share between the 2 servers. I know i can do a replication via FTP but thats not really what i want to do. W...more >>

I have set up log shipping between 2 servers that are not part of any domain. I am using windows nt authentication for all my users. The user names and passwords are identical on both servers. However, the user accounts get registered as MachineName1\username and MachineName2\username and both h...more >>

Hello, I have a push subscription setup to replicate some tables. Initially, this was setup properly and everything was working perfectly. Until recently, the jobs started failing even though nothing was changed. The errors do not give me enough information to find out what the problem is. ...more >>

I'm encountering an error while trying to apply an initial snapshot to a subscriber. The table scripts applied just fine, but when the agent tried to apply the scripts for the stored procedures, I get the following errors: Cannot use empty object or column names. Use a single space if necessa...more >>

How do I go about removing some rouge agents? Specifically, I have a couple of snapshot agents for publications that do not exist. They have the damn red 'X' on them and when I try to start the agent, I get the error....'Error 14262: The specified @job_id ('....bla...bla...bla...') does not ex...more >>

I have recently been comparing the size of the source and replicated tables and realized that indexes are not being replicated. The GLOBAL (Applies to all) article defaults for the snapshot are set as follows: Copy objects to destination Indexes for primary keys are always copied Include ...more >>

hi, i have a database which is around 50 GB in size and is replicated into other server/db. we are installing new version where we have changed nvarchar datatype to Ntext datatype (Alter table) of one of the table which is having 54,09,873 rows. Because of this change log and data file si...more >>

Hi , i need some documentation, hints about how i can connect to SQL Server via MOdem, and how I can replicate data from site who works offline thanks ...more >>

I am in the early stages of setting up replication and I was wondering if someone could offer a little advice. I have an updateable database of around 200,000 records, each described (in great detail) across a few hundred tables. There are also associated tables such as decode tables. The d...more >>

We have replication set up from our production system to 3 other servers. MSrepl_commands table on distribution database was filling up as a result someone tried EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 0 which deleted all rows from this table . soon after ...more >>

Hi, i have two SQLservers, A + B, on different location (they're not network connected to eachother). The onliest possible connection can be through the internet What are the scenario's for me to configer replication between A and B? Do u have a suggestion? ...more >>

Hi, Is it possible to replicate just UPDATE and INSERTS but not deletes. We have a production server and an identical reporting server. We need to maintain 180 days of historical data in the reporting server and 90 days in the production server. Meaning we can not replicate the deletes in the...more >>

I am running a set of scripts to peform log shipping using a linked servers to send a RPC to the standby server sending the log file and path as a parameter for a restore command to be on on the stanby server. For the most part this process runs flawlessly, but when I do have problems it ...more >>

When i specify 'include declared referential integrity ' for an article definition, does that mean that the primary key and foreign key definition on that article are transferred to the subscriber ? If the table Im replicating is a foreign key table and i specify that option but i do not have ...more >>

Hi to all Having an issue with replication which I hope someone can help with. Here is a summary of the processes involved. VB application updates, deletes and inserts into a database (DB1) on our LAN every minute. DB1 is replicated to our website (lets call this Website1) on a trans...more >>

I am not too sure if this is possible..Using Trans Replication Can I have a publication say Pub A on Server A with 2 articles/objects namely Tab1 and Tab2 where they both subscribe to ServerB but on 2 different databases. i.e. Tab1 will go to DB1 on ServerB and Tab2 will go to DB2 on ServerB ...more >>

I scripted our publication in trans replication and found one table/article being filtered vertically so i saw an sp_articlecolumn and immediately after that i saw the sp_articleview which I could not seem to understand the use of that even after reading BOL. Can someone help me understand th...more >>

When working on specific articles in part of transactional replication, I have used it in the past in 2 ways.. One would be sp_dropsubscription sp_addarticle followed by sp_addarticle sp_addsubscription The other would be sp_dropsubscription followed by sp_addsubscriptio...more >>

Hi All, Is it possible to replicate only INSERTS and UPDATES and NOT Deletes. We have a production server and reporting server. The challenge is to keep 90days of data in the production system, and 180days of data on the reporting system. Need to some how to ensure that the cleanups done on ...more >>

We are using SQL Server 2000 on Win2003. I would like to do something like the following on a replicated system. BEGIN WORK WITHOUT REPLICATION; .... <Some insert, update or delete SQL> .... COMMIT; Is there any way to achieve this non-replicated transaction with SQL Server. This needs...more >>

Just hoping to get some feedback on my restore strategy. We've got one published database and two subscriber databases. We're using transactional replication. What I'm working on is a proof of concenpt on how to apply table changes using sp_add / sp_drop article, etc. What I've done is appl...more >>

If I add an article to an existing publication that already has push subscriptions, how can I get the new article to the subscriber databases without running a full snapshot or reinitializing the subscription etc.? I am running SQL Server 2K sp3 on Windows 2K/2K3. Thank you....more >>

We are about to deploy transactional replication with queue updating subscribers. Both the publisher and distributor are on server A and the publisher is on server B. We have one publication on the publisher which will PUSH a small database (around 51 articles) to the subscriber. The MSSQLSERVER...more >>

I have a need to do replication to a warm backup server. My plan was to use log shipping until I read that log shipping requires network shares. That is not viable in our network architecture. Is there a similar way to do this using distributor and subscriber agents communicating directly...more >>

I am running SQL Server 2000 with Service pack 3. I have a database with a transactional publication that is not setup for immediate or queued updating. The tables I am replicating have a primary key that is also an identity column. The publication pushes a subscription to a database on the sa...more >>

Hi All, We have SQL Server 7 installed on laptops , using merge replication with a server running SQL Server 7. We are going to upgrade the server to SQL 2000. Will it be possible as an interim measure to replicate between the SQl 200 server and the SQL 7 laptops. Thanks for any help....more >>

I have a problem with system deletes. The problem occurs when the replication of the system delete results in a conflict. My conflict resolver handles the conflict and wants to retry the delete (because it will probably succeed the next merge phase). So the resolver calls the IReplRowChange...more >>

What is the difference bewteen merge and transactional replication? When to go for merge and when for transactional?...more >>

My publisher is set up as a remote server by default when i set up replication. So when i run an openquery using that server it gives me an error that " the server is not configured for DATA ACCESS." I am afraid to drop it as a remote server and make it a linked server as trans replication is ...more >>

A database that previously was setup for transactional replication and then had it removed, now causes sp_addarticle to go into what appears to be an infinite loop. Does anyone have prior experience with this problem and know how to resolve it?...more >>

Hello all, Does anyone know of any 3rd party software such as NSI doubletake or Veritas volume replicator that works under Windows 2003 64bit (Itanium2) I used to use veritas storage replicator a while back for my Sql 2000, but when we upgraded to Itanium2, nnone seems to support it. I am do...more >>

i am trying to replicate a database in SQL 2000 using transactional replication and on one of the tables, i recieve the following error Cannot insert duplicate key row in object 'F98611' with unique index 'F98611_PK'. (Source: JDEBACKUP (Data source); Error number: 2601) -------------------...more >>

There are 2 tables being replicated with Merge replication. Changes to Table A trigger changes in Table B. My worry is that when the tables are replicated and the changes are replicated to Table A - will Table B be automatically updated? If so, when the Table B is replicated from the publisher...more >>

There are two tables in my DB, with exactly the same schema. Server1.DB1.Table_A and Server1.DB1.Table_A_repl Server2.DB1.Table_A and Server1.DB1.Table_A_repl I would like to replicate from Server1.DB1.Table_A into Server2.DB1.Table_A_repl and Server2.DB1.Table_A into Server1.DB1.Table_A_...more >>

Hi Periodically my SQL 2k snapshot publication database starts to grow it's log file without truncating. - The recovery model is 'simple' - There is no logreader agent, as it's snapshot only. - DBCC OPENTRAN, returns non-zero values for non-distributed LSN, but never returns any SPID! Al...more >>

Hi, I'm having problme when performing the Merge replication and the error as belows: 1) The process could not log conflict information follow by 2) Too many arguments were supplied for procedure sp_cft_xxxxxxx Pls help, it is urgent!!! Thanks. Ringo -- Message posted via ...more >>

Hello: Does merge replication support clustering? I'm having some troubles about merge agent "querytimeout" parameter throught a clustered system, and the hints that are over there about "increasing timeout", "refreshing indices" and a lot more don't give any result. Anyone can help ...more >>

If someone know of a huge replication (hundreds of subscribers merge and bidirectional transac) we could visit (me and my client), i'd apreciate and thank a lot. My client told me he doesn't believe it exists and he would take me anywhere to see it if i could find. Microsoft france promi...more >>

We have 1-way merge replication setup with the subscriber pulling changes from the publisher. We need to have a recovery plan for when the publisher goes down and people start running their apps off the subscriber database. After the publisher server is back up and running what is the best way...more >>

I saw an earlier post on this but since the solution wasn't posted I must ask this question again. Using Hilary's suggestion of placing the snapshot agent on a different drive for performance reasons, I specified \\LASER\PPSRepData as the snapshot folder when using the Configure Publishing ...more >>

Hi Paul, Our company recently had to bulk insert (using INSERT TableName SELECT * FROM...) data into several of our replicated tables on our publisher and we now aren't able to see that bulk data when our subscribers synchronize. I did some researching and read that this is because the mer...more >>

Hi, I received an error message below when I created a subscription: 'Subscriber 'myservername' cannot subscribe to this publication. It cannot create a named subscription because the publication does not allow named pull subscription or because ti is not a registered Subscriber at Pu...more >>

Hello, I am trying to setup a pull subscription through wizard. I have a problem when I choose the publicaiton to which I wnat to subscribe. I can see the publication server, however, there is nothing under it when I expand the publisher. Is that anyone knows what it is worng of it. ...more >>

Hello, I have two SQL 2K server, both are running fine with public IP address. i.e. Server #1: 100.100.100.101 Server #2: 200.200.200.202 I use SQL Server #1 Client Network Utility to create an Alias i.e. SQL2. The alias has the ip 200.200.200.202 and port 1433 Then I use SQL Server #1 ...more >>

If i have netbios enabled on the distributor is there any way to make it not request netbios information to the subscriber? I have the subscriber in the host file and in the client network utility. That should halt nebios request, but it doesn't. The subscriber keeps seeing netbios reques...more >>

Creating a order record form a supplier on the local replica triggers the auto creation of 3 child records in another 2 different tables (accounts/order details). On the local replica every thing went smoothly. During merge, the supplier has been deleted and hence we no longer exist in the d...more >>

Generating 5 fresh different publications (each hold data for one distinct region) over night, so client can download their selection replica. Now what is the cost for such thing? What is the over head per 1MB of data in terms of system tables and in terms of download times on a typical intran...more >>

Hi, Can I create a replica dynamically? No? Why? Yes? then How? More explanation: I am trying to achieve this model. The client connects to the server and request a replica be tailored to contain specific tables/stored procedure etc and then the data tables get populated with specific data...more >>

i've got the following error message, can anybody help me The merge process could not initialize the subscription. (Source: Merge Replication Provider (Agent); Error number: -2147201011 -----------------------------------------------------------------------------------------------------------...more >>

Hello, I want to upgrade my Access 2003 app to have a VB 6.0 front-end and SQL Server 2000 Standard back-end, that I want to sell on the market. I do not want to use MSDE because of the 2GB limitation. My questions are: 1) will my customers have to purchase SQL Server 2000? (or me, an...more >>

Does SQL2K needs the publisher and subscriber to be in same domain? Can we configure merge replication between two stand-alone servers?...more >>

Hi, I am developing a mobile application for Pocket PC and using Pocket PC 2003 Emulator. I am using RDA to pull the data information on the mobile device. When I use "EXEC sp_MyStoredProcedure {Parameters}" the RDA Pull function works fine and creates table on the local sql ce database as ...more >>