Hi i hope somebody can help me as i can't resolve it for 2 weeks now.... situation: trans. replication on win2k3 sp1;sql2000 sp4 as a distributor and a publisher. source and distributor db are on a separate RAID array's. 8cpu+4gb ram. 100mbs LAN. subscriber win2k3 sp1;sql2005 ENT ...more >>

I have a merge publication that I need to change some views and get the new views to the subscribers. At first, i tried the following steps and it failed when trying to synch from subscriber: exec sp_dropmergearticle .... ALTER VIEW ..... exec sp_addmergearticle .... re-created snapshot ...more >>

Hello, I have situation as followed. Do you think merge replication would be able to keep both databases in sync? We have two databases (a primary and a secondary) Regular users use the primary database. To keep the secondary data in sync with the primary, I have a job running ev...more >>

I get the following message from SQL Server Agent: The schema script '\\LUKE\Replication\unc\LUKE$HORIZON_Promise_Promise\20060113160017\Location_1.sch' could not be propagated to the subscriber. (Source: Merge Replication Provider (Agent); Error number: -2147201001) -------------------------...more >>

I set up Snapshot replication using the wizard and got this message the next time it was scheduled to run. There are 7 replication jobs on the server as follows: "Expired subscription cleanup" - this runs once a day at 1 a.m. "Agent history clean up: distribution" - this runs every 10 minute...more >>

Hi All, We are in healthcare domain and we have a complete package written in VB6 and SQL Server 2000. We have installed in one of our clients. This client is actually part of a chain of hospitals. Each hospital can have patients registered with them. Also, this patient could also go to oth...more >>

Is it true that merge replication between SQL7.0 and 2005 is not supported? I would like to setup SQL2005 as a publisher and distributor and SQL7.0 as a subscriber. Can someone confirm that please... Other options in that case would be to use transactional replication or to upgrade 7.0 to 200...more >>

Hello, I am attempting to setup a transactional scheme from an instance of SQL server 2K inside our firewall to an instance running in our DMZ. I am getting the error "SQL Server does not exist or access denied. (Source: <DMZ server name> (Data source); Error number: 17)" I have been readin...more >>

I got a corporate machine has SQL Server 2000 installed. And a laptop has MSDE installed. Is this complicated to setup a 2 way replication in SQL Server 2000 Enterprise Manager? ...more >>

Is there a way i can send a snapshot to the remote computer The database is too big, and the data is already in the remote computer. Everything stoped working when i added a column with sp_repladdcolumn . then i dropped the column to see if that fixed the problem, but it is geting worst I stop...more >>

I have a replicated database that needs a column added to a table with approximately 3.5 million rows. Will it re-synch the entire table to the subscribers when I add the column with sp_repladdcolumn, or simply just add the column? IE, will I be looking at replicating 3.5 million rows to my s...more >>

Hi, Can someone point me to a KB article on how to recover from transactional replication in different scenarios ? Like how to recover if publisher fails or if distributor fails or subscriber fails ? TIA ...more >>

Quick question, do views on the subscription server create locking and blocking issues? I have 2 servers set-up with transactional replication. We have scheduled reports running on the subscribing server, most of those reports using views. The views seem to create performance, locking and bloc...more >>

We are using SQL 2K std with SP4 and push subscription. We have situation between our publishing SQL server and subcribing SQL server. Here is what I see when I double click an action message (listed as Timeout Expired) in the listing of Distribution Agent history. 3:24 pm Initializin...more >>

SQL2K Merge replication. When starting the synchronization it displays "Retreiving subscription information" in the sync dialog and hangs there forever. If I look on the server at Merge Agents, it reads "Last Action:Connecting to Publisher <Publisher name>". Network connection to the SQL...more >>

We are using Merge publication. Some of the laptops (all are subscribers) are showing a status of "Succeeded", but the LAST ACTION listing reads "The process could not deliver update(s) at the 'Publisher'". Is this something to be concerned about? If so, what do I need to look for? Thanks....more >>

Hi! I am trying to understand the replication in SQL server and while reading the book I came across the terms "updatable subscription" and "initializing subscription". So can anyone please help me understanding these two terms with a bit explanation. That would be extremely helpful. Than...more >>

We're getting these errors when DBCC database check about a possible chain linkage problem. We're thinking that there's something wrong with a pointer from an text field to the data. We can do a db repair but problem will show up elsewhere. This only happens on the replicated database btw....more >>

Hi, I have a replication scenario where multiple laptops merge replicate with a central server. The subscriptions are set up as push subscriptions on the distributor. My users want a tool to tell when they last replicated, and if possible, how many records are waiting to be replicated. T...more >>

I have a merge replication, the merge agent job failed with: step 2 : could not retrieve generation information at the 'Subscriber'. NOTE: The step was retried the requested number of times (10) without succeeding. The step failed. step 3: The merge agent job failed. The merge process co...more >>

Hello, My Script is: Sp_repladdcolumn 'tblLensAddOn','IndexNo', 'Int NOT NULL DEFAULT 1','hakim',Null,1,0 and my error message is: Failed to copy user script file to the Distributor.(copy "1" "\\MySERVER\C$\Program Files\Microsoft SQL Server\MSSQL\ReplData\20060...more >>

I defined replication in my SQL Server 2000. I have deleted everything except a remote server. I try to delete this and I get the following error: Microsoft SQL_DMO (ODBC SQLState:42000) Error 15190: There are still remote logins for the server "Name of the server". Where can I find these ...more >>

Hello there If i need to replicate two servers that i don't want that the subsriber user won't be member of sysadmin and db_owner. Which role i need to declare in order to allow transactional replication? -- øåòé âåìãäîø òúéã äðãñú úåëðä èì' 03-5611606 ôìà' 050-7709399 àéîééì: roy@ati...more >>

I've read many posts about what the DRI NOT FOR REPLICATION option is used for but am confused since there are many conflicting opinions. I'd like to have a better understanding of its usage. I have a merge replication containing two tables with a FK constraint between them. Occasionally ...more >>

I have a merge publication that I need to update a published view. I have tried the following but does not work: sp_droparticle drop view create view I need to know if I can do this process without being in EM. Thanks. David ...more >>

I'm trying to set the logging level on a merge agent. I've read KB312292. When I right click on the agent and select properties some text flashes in the status bar but no dialog is displayed. I'm using SQL 2K SP4. TIA...more >>

All, Okay, I need a bet settled. We are about to configure transaction log shipping for our production SQL Server instance. For our sake, let's call the primary server P and the failover server F. I believe that to configure transaction log shipping, you MUST start with two identical...more >>

Hi Yesterday I posted a question regarding our problem with our replication being corrupted with time: http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.replication&lang=en&cr=US&mid=b000d340-bfef-4574-8818-8be420041185 While waiting for repsonse on this thre...more >>

I have a merge replication set up. I need to delete some records at publisher which i don't want to be replicated. What should i do? Thank you....more >>

I'm trying to find out which type of replication takes the least network bandwidth to transfer the same amount of data between two servers. I need to transfer new data from one to another SQL2005 server. I could use merge or transactional replication or even create my own scripts that would se...more >>

Is there a foolproof or nearly foolproof way of emailing SQL notifications, for places not running Exchange? We have logged untold hours on a few different servers trying to get any sort of email notifications going out reliably. There are apparently TONS of things that can go wrong with SQ...more >>

Hello there I have two databases that i use replication to update both of them. Is there a way to disable the triggers of the destination tables while they are being replicated? ...more >>

I am trying to architect a system that will will have one or more machines clustered together. The machines must share a common site database between them. I assume that one machine at any one time should manage the site database. If the machine that manages the site database fails, then anoth...more >>

- What do I need to do column-level 2-way replication from laptops to main database? MSSQL both ends or MSSQL database end and MSDE laptop end? - If I use last-update-wins resolution, how difficult is it to implement? - Where can I find some good docs to guide me? Thanks, Jack T. ...more >>

We are using SQL 2K std with s4 and are using Push subscription method. We need to upgrade some hardware in the subscriber server which will require us to do a total reinstall of the OS and SQL server software. Since we are using push subscription, most of the replication settings are on the...more >>

Got a client who is getting this error when trying "Start synchronizing" on a subscription in Enterprise Manager. When the subscription is run using the Administrator account which originally created it, it runs OK. But when a different account is being used, this error is thrown. Do subscript...more >>

I am working with SQL Server 2005 and having problems with the publisher. After I installed SQL and setup my database, I setup the server as both the distributor and the publisher. Then I setup a merge publication that worked fine with SQL Mobile 2005, I didn't have any problems with synchro...more >>

SQL 2k/Win2K Recently restored a replicated dB, had problems with LSN error, fixed with EXEC sp_repldone @xactid =3D NULL, @xact_segno =3D NULL, @numtrans =3D 0, @time =3D 0, @reset =3D 1 Now I am getting an error in one of my log readers Error: The process could not execute 'sp_repldo...more >>

How do I get a New Table to propagate to Anonymous Merge Subscribers, WITH Add, Update, Delete Triggers? I created a new Table (by running a SQL Script created on a Developer machine) on a Remote SBS 2003 Server (SQL 2K). It Propagated to Subscribers, OK. But it is useless, because is missi...more >>

Hi, We're testing Transactional replication with updatable subscriber. We have kept a machine @branch office which is the publisher and the subscriber is at the head office. Publisher is win 2003 server with win 2000 sp4 and subscriber is a cluster with win 2003 and sql 2000 sp3. For small co...more >>

Does anyone know why if I setup a p2p replication I get: "Could not find a valid Agent Id for the subscription to Publisher XXXServer, ... Source: MSSQLServer, Error number: 21758" This message only happens on the replication between SeverA to ServerB... ServerB replicates to ServerA just f...more >>

I started to play with mirroring with a fresh SQLServer 2005 but I can't get it to work. This is the scenario: server1.mydomain - Primary - Hosts "MyDatabase" - Primary Windows 2003 domain controller server2.mydomain - Future mirror - Secondary Windows 2003 domain controller server2.mydomai...more >>

I'm using SQL 2000 with SP3 and made an replication link to another server. A few weeks ago, I drop the replication and add a new column in both publisher and subscriber server and made a new replication. Recently, I found that a new column did not replicate a data. I check with sp_browserep...more >>

Requirements: - I need to do replication down to the column level. (Last update wins resolution.) - There will be a database located in-house on a 2003 SBS 10 user server - The database will be distributed to users with laptops. They will make changes while disconnected, and then synch up o...more >>

I have two servers, the sql agent service on both servers are running under a domain account - rrg-sqlagent which is an administrator on both servers. The initialization of the database works but 15 minutes later when the the log shipping starts to occur i recieve the following errors. does an...more >>

Suppose I have three servers PARTNER_A, PARTNER_B and WITNESS in a database mirroring configuration, and I want to manually failover from primary (PARTNER_A) to PARTNER_B: 1) What happens to client connections? Are abruptly closed (transactions lost, etc)? Or there is some kind of "wait for...more >>

SQL 2k WIn 2k. I just restored a dB and now I am receiving the following error on my log reader for the restored dB. The LSN (169614:314254:8) passed to log scan in database 'StoreMain' is invalid. I cannot find anything online. Any one have any ideas?? Larry.... ...more >>

We are using SQL 2K standard with sp4 and Push replication. Let me explain my situation here first. We have a weekly dbcc reindex happen at 3:05 am on Sunday morning and finished successfully at 3:42 am. The replication - log reader started issuing error in the log reader agent history, ...more >>

Our application uses a SQL 2Ksp4 Merge Publisher with 1 push subscription and 50 msde anon subscribers. 50 tables to share. I would like the process to treat the publisher more like God and less like a committee member. Ie stop cascading all the changes to everyone and stop creating confli...more >>

Gurus, What are the drawbacks while using TEXT / NTEXT / IMAGE datatypes in MERGE replication Regards Javed Iqbal ...more >>

Occationally, my publisher and push subscribers don't matchup on a few tables. The subscriber has a few more rowguids than Publisher even after synching. Synch glip or conflict or such. What is the best practice to get them matching without cascading more oddities to other subscribers? ...more >>

Hi, I was wondering if anyone has had any success in replicating SQL database with Great Plains version 7.x. I have a server A looking to replicate to Server B. Server B is going to be used as a backup server in the event of hardware failure of Server A. Server B will be also used as a s...more >>

I am curious if having a separate publisher and distributor is better. tia -comb...more >>

Hi, I wrote a job to detect the alerts and mail them to a specific email address. But I realize that the data in msdb..sysreplicationalerts table is being deleted automatically in some time. Why and how often this deletion is made by ms sql? ...more >>

Recently I experienced a scenario that a big transaction happened in a transactional replication database, but we did not reinitialize the snapshot. So it almost took forever for the log reader and distribution agent to finish. In the middle, I wanted to stop the transactional replication and ...more >>