I am having a weird problem that might be able to be cured using parameters, but I can't figure which one. Here's the problem: I have set up a replication over a VPN over the internet. When I connect using a broadband link (1Mbps) everything works just fine. However, when I connect using a ...more >>

I'm using the following process to make schema changes to replicate databases (transactional replication, local distributor, pus subscription): - drop the subscription to the table - drop the article so we can make changes to it - make schema changes - recreate the article - refresh ...more >>

I need to upgrade Sql Server RTM to Sql Server SP3 and Windows 20000 from SP2 to SP4. In which order should these upgrades be done, the OS first or Sql Server first ? John Yard UCLA ...more >>

I formerly replicated a number of databases from one SqlSrver 2k system to another. I have deleted all my Publisher definitions. I notice that my distribution database was not deleted when I did this. In preperation for upgrading to Sql Server SP3a - I am base level now - RTM - should I manuall...more >>

I've been testing replication across several servers on the same machine (and different machines). When I choose to "start over", I will disable publication. I perform this on all servers I'm using. How do I delete the subscriptions? Even after disabling replication they still exist? ...more >>

My question regards if tables in a database can exist in a replication environment with both merge and transactional replication enabled. I have three (3) servers, one of which is only MSDE. The database is the same (structure) on each. Server 'A' has a Merge-Publication to Server 'B' (al...more >>

Hi, I'm a noob when it comes to replication, so please be gentle with me! I've got a need to replicate 2 databases from head office to a remote site over a VPN WAN link (t1/e1) and vice versa. How would I best achieve this? Thanks, Jim ...more >>

Hello I'm currently trying to implement replication with a "Central Subscriber" approach, where every server is only using MSDE. Hence, I only have Snapshot or Merge replication to choose from. Snapshot replication seems undoable since it sends the whole snapshot every single time, instead of just...more >>

We have a test server where developers have test databases for experimentation. As a condition of experimentation, I configured all the database tables to be replicated to determine if replication would cause any problems in our design decisions. So far (earlier post) we have discovered that rep...more >>

What does the svrstatus field of sysservers tell me about how my servers are set up and why I can't access the production server from the attempted replicated server? svrstatus is set at 1089 and keeps going back to 1089 even tho I have used a couple of different techniques found in suppo...more >>

Running SQL & Win 2000 on all servers. The replication monitor is showing that there is an error in my Merge Agents folder. When I expand the Replication Monitor->Agents->Merge Agents, there is no error on any of the Subscriptions. How can I clear this up?? Is there really an error and...more >>

Hello All Friends ! If any body wants to delete All Merge Replication Tables,I have the solution Pls write to me At -vinbisht@yahoo.com Can any body tell me how to delete Rowguid column which gets generate in table After Replication whether Replication Sucess or fails, and I want to know dif...more >>

Dear Friends While creating the replication i have got the following=20 alerts in the wizard of Replication kindly suggest what=20 action i have to take so taht the replication will go=20 smooth. I am fresh for the replication so please do not=20 mind if the question is simple. Thanks in a...more >>

Hi NG, after setting up a transactional replication we get the following error from the distribution agent "Could not find stored procedure 'sp_MSins_alarm_log'. (Source: ESLTSRV2 (Data source); Error number: 2812)" Both servers are running SQL 2000 with SP 3 under Windows 2003. The Servers ...more >>

Hi In order to avoid sending millions of records over a telephone line the first time a subscriber synchronises, I've recently tried finding alternate ways of synchronising. I came up with Synchronization Partners. If I understand the documentation correctly, a Sync partner is used as an alte...more >>

Hello there! I am preparing a new server for the databases we use ( an accounting program using SQL Server 7.0 on a W2k Server), but the main specialist from the accounting software maintenance team tells me there is no backup for the replication settings, so he is very affraid he will...more >>

Hi~~ I'm using merge replication. I've got this message. The snapshot for this publication has become obsolte. The snapshot agent needs to be run again before the subscription can be synchronized. Anyone knows how to do replication without reinitialize it. ...more >>

Hi everyone! I'm a bit confused about the arguments for the sp_addpublication_snapshot procedure. The SQL Server Books Online are somewhat vague about how a few of the parameters interact with each other, and it's left me scratching my head wondering how I should set them So, if someone could, I...more >>

Hi there, We have a SQL server 2000 SP3 database that provides a pull subscription to our MSDE 2000 SP3 laptops. We programatically activeate the pull subscription via our VB6 application. We have a major security problem in that when we do the inital install the first time we pull the...more >>

I got a problem. When setting up repplication the Snap Shot Agent starts to create files in the file path \\SHBAS\E$\database\files\MSSQL\ReplData\unc\SHBAS_SHBASTest_SHBASTest\20040115162020 it works fine until the process suddenly stops and the snapshot agent seems to rollback I get the fo...more >>

Hi Folks, We are in the middle of developing a system for our factories which are spread out over the globe. Part of the system involves each factory replicating its database to a hub server. We are currently experimenting with transactional replication which - although mostly fitting the bil...more >>

Hello, I'm doing transactional replication and I got this error in my distribution agent log. Would someone knows what I need to do to fix it? Thanks!! The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a ...more >>

I am attempting to setup continuous Transactional replication from 1 server to another with SQL Server 2000 and have (or so I thought) gone through all the appropriate wizards. However, after modifying a few rows in the publication, I see no changes in my subscriber. In Enterprise Manager, whe...more >>

I am testing replication and am unable to set an identity range for one of my tables, which is an article. Both the publication and subscription database have an identity column. Any suggestions?...more >>

Running SQL & Win 2000 on all servers. The replication monitor is showing that there is an error in my Merge Agents folder. When I expand the Replication Monitor->Agents->Merge Agents, there is no error on any of the Subscriptions. How can I clear this up?? Is there really an error and...more >>

I am having the same problem that appears to be referenced in this posting: http://groups.google.com/groups?dq=&start=325&hl=en&lr=&ie=UTF-8&oe=UTF-8&group=microsoft.public.sqlserver.replication&selm=02e801c3bf57%245acead20%24a301280a%40phx.gbl I have also checked read and followed the instru...more >>

I want to create a merge publication on a computer running SQL Server 2000 SP3a on Windows 2000 (Build 2195: Service Pack 4). When I run the script I get the following error after running the sp_addpublication_snapshot line: Server: Msg 2758, Level 16, State 1, Procedure sp_helpmergepublicat...more >>

All servers and SQL are 2000. I am doing transactional replication between one central server and several remote servers. I deleted some rows from the publisher in query analyzer, but the deletes were not replicated to the subscribers when the distributation agent ran. If I perform an u...more >>

What is better linked servers or Remote servers for duplication ??? Thanks ...more >>

Hi All, We're currently thinking about implementing a Master / Slave SQL Server setup so we can essentially mirror our production server so that we can have a workable backup should the production server experience problems, and which we can use to run our reporting queries against, leaving o...more >>

Hi! I have a sqlserver 2000 database and want all that tables daily transfer to my oracle 9.2.0.1.0 database. what is the best way to do that? thanks ...more >>

Hi, Our production database has been replicated used transactional option. Now the secondary site database data file drive run out of space. I need do detach, move data file to another drive, and attach it again. The questions are: 1) Can someone tell me the stored procedure sp_remov...more >>

If i implement Transactional replication and users input data into the db by means of Bulk uploads with Excel. Will the uploads be replicated? If not what would be a solution to make sure that my bulk uploads get replicated? Snapshot may be out of the quesiton as i have a 3GB DB and would l...more >>

Hello I am trying to set up replication from SQL Server 2000 SP3 to DB2 7.1 in mainframe. On SQL-Server I setup a Snapshot-Replication and push-Subscription to the Host. We are using IBM DB2 ODBC DRIVER from DB2-Connect to setup the subscriber. All goes right until I start the replication The s...more >>

I am running Transactional replication on SS 2000 service pack 3. Push subscriptions. I have the agents set to fire every one minute. The agent for one client stopped firing the agent. The server was rebooted and the agent started to fire again. Why did the agent stop firing. I noticed this happened...more >>

wat is the different between snapshot and merge ab ----------------------------------------------------------------------- Posted via http://www.mcse.m ----------------------------------------------------------------------- View this thread: http://www.mcse.ms/message289469.htm ...more >>

Dear Experts I've a system which is run by sql servers (one central publisher with 20+ subscribers in different locations). The replications between them are either push, pull or merge modes. The replication volume is at least 2.5 million records per day a different time intervals, e.g. 1 min,...more >>

It's my first time to replicate a database. I'm doing a transactional replication for real time backup and I noticed something I didn't expect: 1) User defined data type didn't get created in the subscriber 2) Constraints didn't get created in the subscriber 3) Triggers didn't get created in t...more >>

We are replicating from one SqlSrvr 2k system to another. Some of the publisher tables have identity columns; we modified the corresponding tables at the subscriber as Identity Column Not for Replication. So far so good. We are planning to drop replication , and the replicate in the other d...more >>

I've set up a pull-merge subscription. The thing ran fine for 3-months. All of a sudden this week it started to fail with the following error The process could not deliver the snapshot to the Subscriber (Source: Merge Replication Provider (Agent); Error number: -2147201001 ---------------------...more >>

I have an OLTP database that is currently 172 GB and has 16.5 GB of transaction changes through out a normal working day. I have configured a Distributor server and have configured my production server as the Publisher. I currently have two 100 MB NIC cards (adaptor team) on the production system ...more >>

Could not remove directory '...dir'. Check the security context of xp_cmdshell and close other processes that may be accessing the directory. [SQLSTATE 42000] (Error 20015) Associated statement is not prepared [SQLSTATE HY007] (Error 0) Replication-@rowcount_only parameter must be the va...more >>

Hi All, We have installed Two SQL 2000 servers. DB1 (main database) configured as a distributor and publishers and DB2 configured as a subscriber (backup database). The procedures I did the replication: 1. full backup the whole database said "test" on DB1 server. 2. Create a new data...more >>