Hello, I am working on a project where we have a large database that is replicated. My task is to create a backup/restore plan for this project. I know the basics for backup/restore, but are looking for best practices and experiences from you who have done this already on a large scale. B...more >>

sql2k sp3 Whats good/ bad to checking/ not checking the "Do not lock table during snapshot..." button? TIA, ChrisR...more >>

Hi All, [CURRENT SET UP] I have two SQL 2k Ent servers in two locations. SVR1 has 2 publications (snapshot and merge) the SVR2 subscribes to. SVR2 republishes these, so that a number of local MSDE clients can subscribe to them. SVR1 also has a number of local MSDE subscribers. [PROBLEM]...more >>

Hi there, we are using merge replication with anonymous subscribtion. window 2000, sql 2000 sp3 - server wind 2000/XP, msde 2000 sp3 - subscriber Synchronizing data with Active XControl. we have around 50 subscriber and in our database we are using identity range management(defult by...more >>

Hello All, I have a database that is going to be replicated. I need to keep only about 3 months worth of data but the replicated database needs to keep about 3 years worth of data for reporting. What's the easiest way to do this? Is there a way to have replication not replicate the deletes? I...more >>

We decided to replicate a database post-design and deployment and have had a few struggles. The first one was with the numerous foreign key constraints that were not marked NOT FOR REPLICATION. We altered them and are now not getting duplicate data errors. I understand that this is b/c certain up...more >>

Hi, I have establish transactional replication between 2 of my servers, everything were fine for about 2-3 months but now it stops Violation of primary key constraint 'PK-measure'. Cannot insert duplicate key. It is also strange how it could happen as I have the same db constrains on...more >>

I am having a problem running a merge replication between a SQL 7 publisher/distributor and a SQL 2000 subscriber (push). After the subscription is initialized, the agent fails with the error "The process could not query row metadata at the Subscriber." The error details says "Could not fi...more >>

I need to know how to add a new column for the client using Merge Replication, the book I have is cryptic as all getout. It looks like I can use sp_repladdcolumn but do I need to shut anything down, turn anything over, flip anything around... Thanks in advance....more >>

The documentation point out that "distribution agent utility" can accept the option "-ErrorFile". But the distributor always refuse it. Why? Thanks ...more >>

I use replication with dynamic filters. In my system it is possible that data is added to the subscriber that doesnot pass the filter. When replicating, this data is deleted at the subscriber and added to the publisher. Why deletes the merge agent data that is not in the scope of the dynamic ...more >>

Hi All, I need to change the value of -ExchageType in a Merge Publication , How could I make it ? Thanks in advanced, Ray....more >>

Hi, I have a table that has different owner than DBO. When I include this table in publication, SQL Server does not allow to enable automatic identity range for this article. Any help would be greatly appreciated. Leila ...more >>

Hi, I'm confused. I have bidirectional transactional replication configured between 2 servers (sql server 2000 sp3). Same table is publisher and subscriber on both servers. Execution of: sp_helpsubscription <publication name> shows that loopback_detection is set to "No" on both serv...more >>

We want to create a reporting database from our OLTP database. We are thinking to take an initial snapshot and then use transactional replication. However, we also want to keep the OLTP database with only one year of data. If after one year, we remove records from OLTP, the transactional replic...more >>

I am using merge replication with SQL ver 7, on a NT4 box. I need to move one of seven subscribing servers to a new location which means changing the IP address. I want to do the move without taking down replication if possible. My plan is to move the box and change to new IP address. Then u...more >>

Hello, What requirements do i need to setup replication. I have a sql server running at one location where the most updates occur and another location where minimum updates occur (mostly read data requests). The bandwith to connect each other is beneath 512kb. Thnx ...more >>

Hilary, Paul. I have read some of your threads on some sites regarding this. You had suggested that maybe restarting sql agent/server would resolve this. I tried that with no luck. I have yet to reboot the server, because it's in a production enviroment. I will try that this weekend...more >>

Hi All! I have a Merge Publication of two tables with several subscribers. Now, all data of two tables are in server and all subscribers. I want to filter data of one table. This filter depends on value of one field. I need several subscribers will have rows which "myFilterField=1", others...more >>

Hello, Within a merge replication scenario I keep getting the error message "The process could not enumerate deletions at the 'Publisher'". I set the query timeout higher and keep getting the same error. Can anyone tell me why this is happening? Any help would be greatly appreciated!...more >>

What dB should sp_MSload_replication_status executed in to fix that pesky red 'X' in replication monitor?...more >>

Hi, I have transactional replication with queued updating. When I'm running this function on subscriber: INSERT INTO matchup_edge (fk_game_id, offense, defense, coaching, misc, intangibles, overall, evaluator) VALUES (1292, - 1, - 1, - 1, - 1, - 1, - 1, 'Covers Team') SELECT @@...more >>

When replicating across a firewall are there any special considerations that need to be made for the SQL Server Agent? A colleague mentioned that he saw some information detailing the configuring of firewall ports for the SQL Server Agent. With SQL Server Agent being another client to SQL Ser...more >>

We have a db that we would like to replicate. The plan is to use transactional replication on this server (db1) and push it to another server(db2). db1 will be the publisher and the distributor, while db2 will be the subscriber. Currently, db1 is not replicated and our backups are setup...more >>

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