hi , We are experiencing a problem with statistics not getting updated (row counts in sysindexes) after we upgraded our SQL server to SP3a (upgraded from RTM). We are using transactional replication from a publisher (SQL 2000 RTM) to a subscriber (SQL 2000 SP3). The row count statistics...more >>

Hello there I've started creating my own replication between two databases with the same structure: Local server and internet server. The Internet server is not updated. When i configure the local server for replication it gave me an error that i can't use the local server agent. Afte...more >>

Hi all, Please help me with issue. I have the following error accured always when i run the merge agent. I have 3 database makes replication, 2 are running and is giving this error: LAST COMMAND : {call sp_MSenumchanges(?,?,?,?,?,?,?,?)} The process could not enumerate chang...more >>

How do I determine if a subscription has loopback detection enabled?...more >>

Recently one of my remote sql servers crashed. This server was a publisher that replicated 8 pubs to a subscriber. I reinstalled the sql server and restored the published database from a backup. I then proceeded to set the replication to a new subscriber database. Eache time I try to run the ...more >>

SQK 2K I have a cronic problem with several of my servers with the replication monitor 'Distribution Agents Folder' reporting that is a problem, but when I check the Agents, there are none. I have read this is due to corruption in a temporary table and restarting the SQL server will fi...more >>

We use veritas Backup Exec for Hourly Transaction Log BAckup Would it be possible to integrate Logshipping with the Translog backup performed using veritas Backup Exec? ...more >>

hi all, I want to setup replication on Access Database.. I want data will be updated in SQL Server from Access database.. 1) Which replication type will be best suited (merge or transactional) 2) How I will setup subscription on Access database. Whenever I try to create a push subscription ...more >>

Hello, I have a 27GB db that I need to setup as a publication for merge replication in the upcoming month. I'm assuming that the initialization process will take a very long time to complete including the snapshot. If anyone has any advice on speeding up the process please do so. My ma...more >>

I'm trying to setup a publisher on an msde database and am getting an error when running my script. The error in the event viewer (and job history) is - Step 2 of job 'machine\instance-database-1' cannot be run because the LogReader subsystem failed to load. The job has been suspended. ...more >>

Hi, I just want some advise on how often the initial database dump should be applied to the standy server. Do I just apply the inital backup and then the transaction logs thereafter or should the database be restored nightly on the standby server? Thanks ...more >>

Publisher: SQL 7 SP2 Subscriber: SQL 2000 SP3 Both in same Domain running Win 2K svr I have transactional working fine with the above servers pulling from the subscriber. Have added a Merge publication. If I try to set up a pull subscription the Merge one doesn't appear in the list of...more >>

I need to restore published database from backup. Do I need to restore distribution database ftom the same point in time or I have to rebuild replication? Any sugestins are welcome. Thanks dk...more >>

Hi all, I don't know if this question belongs here but I will give it a try. ;-) I have a transactional replication of five tables from one db to another db at another site. The replication is very critical so there must be no delays, and hopefully the server will never go down. ;-) When us...more >>

This is not my problem. http://support.microsoft.com/default.aspx?scid=kb;en- us;813494&Product=sql2k I need to know how to prevent a replicated record from being re-replicated. I know there is a flag. HELP!!! >-----Original Message----- >Running SQL 2K & Win 2K >I have 16 servers tha...more >>

Hello, I am working on a distributed database system in which each site is a publisher of a filtered set of data. It is necessary that a publisher can subscribe to another publisher. I am using merge replication, dynamic filters and push subscriptions. Each site publishes the same tables...more >>

Hi, I have 750,000 commands in the table MSrepl_commands. The cleanup agent hasn't removed them, although they have all gone to my one subscriber, and I don't have anonymous subscribers. What am I missing????? Rgds, BB...more >>

I have a Publisher replicating to 3 Subscibers. Following a db change replication with 1 of the subscibers fails and the following error is received: The process could not read file '\\KRONOS\REPLDATA\unc\KRONOS_OASISSQL_OASISSQL_21070 4\20040927153216\RFI_836.sch' due to OS error 1311. (...more >>

once in a month (at least) my merge replication failed with these errors: at subscriber's side: Category:NULL Source: Merge Replication Provider Number: -2147200994 Message: The process could not make a generation at the 'Publisher' then Category:COMMAND Source: Fa...more >>

Just wondering how the on line ticketing system for cinemas replicates data for ticket booking ? I mean whose sytem that handle serveral cinemas in different location within a town. It seems too risky if they use centeralised system that all data store at one server, as failure of the server ...more >>

Hello, we have a requirement to sychronise data between 2 databases located across the firewall. Both are MS SQL Server 2000 servers. Can u please suggest some options. Would any of the replicaiton methods work across the firewall? regards Narendra ...more >>

tia, --oj. ...more >>

Can someone give me a pointer on how to set up a replication server? I've browsed the replication documentation, but I just want to know what the experts suggest for what I want to do. I have two servers, Office and Home, with Internet access over 384k DSL line. Office is the publisher, an...more >>

Running SQL 2K & Win 2K I have 16 servers that use trans. replication to a central server... I want to replicate all data to the central server, this is not a problem (Trans. Pub 1). Next, I want to filter the data and replicate location specific data to each server, this also is not a p...more >>

I do it select @@version on sql query analizer and the result is: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 4) how can I know the servic pack version ...more >>

any idea how resolve this error on replication? "call sp_MSget_repl_commands(29, ?, 0, 7500000) Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__2813BD1E'. Cannot insert duplicate key in object '#271F98E5'. " Here's the MS Knowledge Base reference : Q320603. I did executed the...more >>

I want to replicate 3 tables of our ERP database to be used only for selects at our other site. Our other site is connected via a persistant VPN connection. I currently have tranactional replication running. The problem that I am having is that sometimes during the overnight time frame, r...more >>

Hello, I want to develop for my own little database on the Desktop which contains one table (5 columns - always nvarchar-types) a replication between PocketPc and Desktop. I have already read the example at http://www.msdn.microsoft.com/SQL/SQLCE/default.aspx?pull=/msdnmag/issues/03/09/dat...more >>

Hello there as i understand i can use log shipping if i have two databases on diffrent servers with the same structure but not with the same data I would like to move diffrent data from one of them to the other In the help i can't understand what should i do for doing this any help woul...more >>

Hi, I have a single publisher and multiple distributors scenario. The publisher will be a SQL Server 2k and the subscribers can be SQL Servers or MSDE's. I have set up pull subscription from the subscribers and i am using merge replication. My application provides addition of new colu...more >>

sql2k sp3 Transactial, 1 way replication to 1 Subscriber. I want to offload as much processing to the Subscriber as possible. I was thinking to use a Remote Distributor (Subscriber) with Push Subscriptions would be good. (Push for Security/ Firewall reasons.) Is this correct thinking? TIA, ...more >>

I have a database that is being merge replicated between 1 publisher and 2 subscribers. One of the tables in this database has it's replication conflict resolver set to be a stored procedure which uses 2 cursors, 1 to determine which record the GUID being passed in corresponds to (right out o...more >>

Hi, I created a merge replication. I have 1 article and with Subscriber Always Wins conflict resolver selected. My problem is when I insert in the publisher table and in the subscriber table a few rows at the same time (for example 3 rows, the same rows in both, inserted by my...more >>

HI, We have a pbulisher and a Distributer in the same server and a subscriber in diffrent server but it is in LAN. I am using the transactional replication between the publisher and subscriber. I have a alter script, to add timestamp column to the subscriber and written the triggers to popu...more >>

Hi, I have created the transactional replication between the publsiher and subscriber.It is working fine.Now I want to pull the diffrential data from the subscriber ever day and write to the file. Can any one help me,how to pull only diffrential data from the subscriber. I turly appreciat...more >>

I've been trying to work through the example listed at = http://www.databasejournal.com/features/mssql/article.php/1438231 but I = keep getting the following error when I try to create the pubs_article = publication: SQL Server Enterprise Manager could not create publication = 'pubs_article' ...more >>

I am working with a VB.Net Windows app that creates a publication/subscription on the fly. Essentially, it takes a database backup in a zip file, unzips it, restores the database to the same server as the other database in the setup, creates a publication to the first database, then a subscripti...more >>

where can i find a white paper on step by step replication setup...more >>

Hello, We suddenly started having this error message, does anyone who what it means ? The job failed. Unable to determine if the owner (XXXX\XXXX) of job Agent history clean up: distribution has server access (reason: Could not obtain information about Windows NT group/user 'XXXX\XXXX'....more >>

Dear All We have a Corporate office and three branch offices which are connected with 128 K ISDN connection, My central database is located in Corporate office, I have developed an order management application. Order at all the branches are handled separately but I want that all the branches ...more >>

Hello there I have two databases which are the same structure I need to transfare any change on the first database to the other one how can i do this? ...more >>

I have 9 tables that range in size from 60gb to 1.5mb. dpvHstGndItem 59821.2 DpvHstCheckSummary 55421.5 dpvHstGndTender 32165.9 ItemByStore 396.136 Item 2.952 Category 1.752 Tender 1.632 gblStore 1.52 CategoryItem 1.304 dbname = aaa01 aaa01 sits on publisher vs...more >>

Hello, they excuse by ingles. I hope can understand to me. I have several BD SQLSERVER 2000, which all are of the same structure. But one in each city, the objective is to know if I can use the option of Merge to maintain all the data bases synchronous. Exists algun problem if the servants whe...more >>

Dear Friends, I have created the transactional replication between two servers.I have a few triggers on the subscription database.These triggers are very simple, just I am updating the timestamp column in the subscription database whenever, the record is getting inserted or updated to this ...more >>

I'm getting this error with a transactional replication publication I'm working with, I think my distribution database is hosed, I got another error cannot find object syspublications, I'm just kind of wondering how it got that way and how I can fix it... TIA SQL Server Enterprise Ma...more >>

Merge replication fails several times but winds up eventually succeding. It seems to correlate with known congested times on the internet like Friday lunch time. Are there any settings I can tweak to to make it more resistant to these types of problems? possibly increasing a timeout value somewhe...more >>

Hi, I have two-way transaction replication. Set of tables from several databases is being replicated from server A to server B. Problem is with only one database. Everything was working OK until today. Log Reader agent failed, and when I restarted log reader job of this database (always ...more >>

I am new to SQL SERVER and need to link MS to Oracle. We have an Oracle database where we need to pull some data from through a procedure. Can you please give me step-by-step instructions on how to do this (the Dummy guide). ...more >>

Hey everyone, I'm currently running sql 2k sp3 and win2k3 with all of the latest patches. I'm running merge replication in a clustered environment. My question is in regards to the cascade delete option for foreign keys. Whenever a delete transaction is executed against the parent table ...more >>

first: forgive me, is it indices or indexes? I had previously asked about adding indexes to tables that are a part of merge replication (sql 2000 servers). Paul Ibison reccomended checking out sp_addscriptexec. I honestly have not done that yet as I was just doing a little initial digging on t...more >>

Does snapshot replication need uniqueidentifier (Is Rowguid) with PK on it? Does anybody now a good article that talks about using uniqueidentifier on different types of replication? Thanx. *** Martin Bajc ...more >>

I keep getting Timeout Expired with {call sp_MSget_repl_commands(8, ?, 0, 7500000)} in the error detail when attempting to replicate a 9.2gb database over a wan link. The replication is transactional and other smaller test databases replicate just fine. Any clue as to what this means?...more >>

This is the scenario: I am do log shipping from one server to another. I have 9 databases that I am shipping. 8 of them work flawlessly. I have one that for some reason either always goes into a Suspect state or into a Loading state. It just stays there until I do a manual restore. I ha...more >>

SQL 2000 The goal is to have the subscriber being a backup server that's getting its data via merge replication from the publisher. If the publisher goes down, the subsciber can take over as the main server. So, when setting up push merge replication to begin with, I push a snapshot to...more >>

Hi there, Is there any issue related to SP3a and Merge Replication? we recently upgraded our 3 servers to sp3a and since then the merge replication has been partially failing. There are no error messages. the only symptoms are that (only) some of the data doesn't replicate. We cannot see ...more >>

After implementing a password for the sa account, I'm getting the error: ODBC Error: Login failed for user "sa" I thought that there was stored procedure where I could set the password for the Queue Reader Agent but I can't find it. Can anyone assist me here or have any insight into this ...more >>

sql2k sp3 Im attempting to use Custom Sync Objects for Replication. My scenario is that: Publisher: Table1 (column1,column2) Table2(column1, column3) Subscriber(column1, column2, column3+ created on the fly values) Im having lots of trouble with the Update Proc. I'll post the sc...more >>

Hi all - can anyone tell me of a KN article or something published online that covers the security risks involved with FTP with replication? If you don't know of an article could you please give me an overview of what risks I should consider. Thanks....more >>

I am currently running SQL 2000 SP3 as the backend for one of my production systems. I would like to start doing some kind of repication for quick diaster recovery efforts. Where would I find instructions for doing this. I have plenty of hardware available....more >>

The Merge Agent for a filtered publication failed and I got the following error message: Message: create table #belong_agent_-2147483646 (tablenick int NOT NULL, rowguid uniqueidentifier NOT NULL,generation int NULL, lineage varbinary(255) NULL, col v varbinary(2048) NULL) How Can I get...more >>

hi all, my question abount the size of the databases in MergeReplication.initially both the publisher and subscriber databases data file is 1GB.After two days the subscriber size is increased to 1.25GB and publisher size remains same. what issues of MergeReplication will increse the size pl...more >>

Hello, SQL 2000 SP3 I have made publications with 158 articles and static filtering. The first snapshot ran in 16 minutes. After that almost the same publication (but with another static filter) takes 35 minutes to complete. The amount of records in each publication is almost the same. ...more >>

I'm running into problems with a merge publication where I am trying to use both subset (dynamic) filters and join filters. I was hoping that the join filters operated on the slice of data carved out by the subset filters, but that doesn't appear to be happening. Instead, the union of the resul...more >>

Hi There, This is what happened with me. I had a conflict between publisher and subscriber and ALAS!!! subscriber won. I want to set up so that Publisher always win ... How can I do this?? Thanks Vivek ...more >>

HI, I am getting this error when I try to do a transactional replication. The process could not bulk copy out of table '[dbo].[syncobj_0x4446463436393841]'. Any help will be greatly appreciated. Thanks...more >>

We will be using connecting our 2 sites through 2 firewalls, and having push subscribers. I'm new to this type of network infrastructure so please excuse my naive questions :) (1) does this mean that we will be using a VPN? (2) Do we have to use FTP for initialization or can we use t...more >>

Does anyone see any problems with do an "Add File" to a publisher or subscriber database, while replication is running? ...more >>

Hi, Is there a way to add the "not for replication" option to an identity field without rebuilding the entire table. Thanks in advance....more >>