...more >>

I made two one publications and after i deleted them but two subscriptions still remain.How Can I delete them Thanks in advance...more >>

I have two databases called A (source) B (destination) A replicates 10 tables to B, next day if I change the setting to replicate 5 tables instead of 10 it will delete all the tables in B and recreate only 5. my question is how to keep that other 5 tables that was created during the previou...more >>

Hi, I want to use SQL Server replication in a scenario where the Publisher and multiple subscribers are connected over a very low bandwidth. Is that possible to write down some scripts/programs which does the following 1. Create a file containing changes made locally during that day on each...more >>

I restored a dB and set it as read-only. The dB is being used for replication, so in my Replication Monitor in EP, all the publications are listed numerous times. I cannot detach the dB because it is being used for replication. I cannot use sp_removedbreplication because it is read- only...more >>

Can I setup transactional replication up in which the publisher and subscriber are on the same server...? The problem we're trying to solve is we have a set of tables that are very large, we have a front end in which the user can define an ad-hoc query to run against these tables, to improve per...more >>

Running SQL 2K & Win 2K I had to bulk insert 220,000 records into a table that is replicated via a transactional publication. The Log Reader gave me an error indicating that I had to increase the size allocatedto the dB. I did this and this error disappeared. I am now getting a timeout...more >>

Hello everybody I have to set up a transactional replication between two server W2k with sql2000 sp3 I'm experiencing problems with initial snaphot, because: 1 - the replicated table at subscriber is not initially empty (and I can't loose data already present in it) 2 - it could contain some...more >>

I received the following error message after fours days of SQL Server 2000 transactional replication. Output Error from LogReader: The process could not process 'sp_replcmds' command. What would cause this error and stop the LogReader? Thank You, Dan ...more >>

Hell I have made a merge replication between two server W2k with sql2000 sp3. Those servers are connected via internet. In distributor (also publisher) I have setting up aliases for both servers. Have generated snapshot but when agent run I have this error: -2147201019 and 14010 : "the subscription...more >>

Hi all, last 9 april 2004 is occured this error: ----------------------------------------------- "Event Type: Warning Event Source: SQLServerAgent$SQLQRS Event Category: Printers Event ID: 208 Date: 4/9/2004 Time: 6:10:06 AM User: N/A Computer: Description: The description for E...more >>

We are replicating from SQL server 2000 DB to Oracle 9i database using a 2 Mbps line. When there is a mass update on our DB, the same is replicated to the Oracle 9i side, but apparently the SQl Server sends as many update/delete requests to Oracle as the number of rows affected on SQL side (17000). ...more >>

Hi friends, How to configure email notify in replication ?, so, sql admin will know immediately if replication process is fail or succed. I already configure mail profile in sql agent, it works properly. I try to configure email notification in log reader agents and distributor agen...more >>

We have 2 sites which are normally connected by a 10mb fixed line, I'm looking for a backup should this link fail. Both sites use the same software connected to a sql server database. If the link fails both sites should be able to continue in a limited capacity and once the link is restored the ...more >>

Hi, For a typical one publisher, many subscribers merge scenario, is it possible for selected tables to replicate bi-directional, and others to replicate uni-directional? How? I am not sure if the direction (ExchangeType property) is fixed for the whole subscription, or can be set at table le...more >>

I have set-up replication using transactional publication and I have configured subscription to be near continuous. I have this issue. When setting up subscription I have specified that the subscription database already had data. So when the snapshot agent is initialized it does not recreate...more >>

After installation of SP3a on the publication server, clients are getting errors during replication. The error detail is : "Select permission denied on object 'MSDistributor_access', database 'tempdb', owner dbo ...more >>

Hi There, I am trying to apply initial snapshot to our client who are going to access through internet. I publishe data and check available using ftp. While synchronizing from subscriber i am receving following error message. the schema script '\\TESTSERV01\C$\Program Files\Microsoft SQL ...more >>

I'm trying to set up a merge replication of a SQL 7 database for the first time. I configured the server as a publisher and distributor. I changed the default location for the snapshot files to a shared directory and made certain the account running the SQL Server agent has Full Control ac...more >>

Running SQL 2K & Win 2K I had to bulk insert 220,000 records into a table that is replicated via a transactional publication. The Log Reader gave me an error indicating that I had to increase the size allocatedto the dB. I did this and this error disappeared. I am now getting a timeout...more >>

Hi, I try to simulate transaction replication in my server. I create 2 sql 2000 instance in my server: sql1 and sql2 sql1 : publisher and distributor sql2 : subscriber I want to replicate sample db 'pub' in sql 1 to sql 2 I got this error : Could not find stored procedure 'sp_MSupd...more >>

In the snapshot agent error details, there is an error - The process could not bulk copy out of table '[dbo]. [syncobj_0x4243303245434335]'. - The process could not bulk copy out of table '[dbo]. [syncobj_0x3537344643413741]'. Full message is I/O error while writing BCP data-file. ...more >>

Hello All - Is there a process that automatically cleans the conflict tables? I have a merge publication with publisher & distributer running on same machine. This is SQL 2K and W2K host. The clients are push subscription. I viewed several conflicts last week ( Friday) and postponed res...more >>

Hi There, I have access adp file for the frent end and MSDE for the back end for the client. client need to synchronize to the main server sql 2000. I wanted to put the botton on the front end of our application for the synchronization. Is there any way i can do this rather than go to EM f...more >>

Hi All We have setup Transactional Replication with queued updating subscribers option. Our Servers are in Failover cluster with windows 2000 AS. We are doing Full and Transactional log backups as usual. Can any one suggest what are the recovery scenarios, in case of Publisher (if it is completel...more >>

I am running SQL 2K & Win 2K. I restored a backup, to a different name, that was being replicated when it was backed up. After the restore, I cannot detach the backup, because SQL thinks it is being replicated. How can I fix/detach this dB???...more >>

Hi There, I would like to filter the row in several tables in merge replication for the subscribers. I would like to filter the row with the criteria saying only trasfer the data for last week or latest last(7 days data) to the subcriber and the second option is first 100 rows. If there is an...more >>

I've set up log shipping between a production server and a secondary server, all work fine. Now I want to use the secondary server or the warm standby server to do complete database backup every night, since I want to off load the backup from the production server, however, I get this error message ...more >>

If the Log Reader Agents job gets deleted.. is there anway to recreate it short of rebuilding the publisher?...more >>

(Repost from another forum I put this in -- just in case!) It's really not pretty to beg -- but... I have a really impossible situation to solve...and just can't 'see' it on my own. Anyhelp would be greatly appreciated. The problem is the following: a) An Edge table -- any of the...more >>

How do I get rid of this message: Transaction (Process ID 70) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (Source: EMDATA (Data source); Error number: 1205) I have several remote locations, all of wich have severa...more >>

Hello... I am noticing that everytime the the Agent history clean up job runs... it causes contention and blocking in the distribution database. Has anyone come across this? If so, how did you resolve this. I am using SQL Server 2000 and every server in my topology uses SQL Server 20...more >>

Is there a limit to how many databases can be replicated in a MSDE 2000 environment? We have several servers with several replicated MSDE 2000 databases. It seems that we are hitting a limit because we cannot replicate any more databases. Any ideas? ...more >>

hi, in a merge replication I use a view (V1) that references another view (V2) in its select statement. when running the merge agent to initialize the subscriber I get this error: The schema script '\\SSS-SERVER\ReplData\unc\SSS- SERVER_E5K_714_FS_E5K_714_FS_Replikat\200404072145 58\V1_6...more >>

Hi, my problem is: we have poor line between servers. To avoid this issue i created new profile for distribution agent. This profile has been created with bigger QieryTimeout and LogonTimeout values. After that i assigned this profile to distribution agent and SQL Server agent was restarted...more >>

How often should the snapshot agent job run with merge replication? My schema won't be changing anytime soon but I will have new subscribers coming on everyday until we get everyone on board. Thanks Tina ...more >>

hi, we are using merge replication for our 30 remote sites. our publisher is in full recovery mode. we are backing up transaction log file every 4 hr. our replication is happening through out the day. log file is about 5 GB does that cause some problem to replication performance . tha...more >>

We have 30 remote subscribers and a publisher.We have experienced in past that the conflict tables grow to the limit and for some reason after that we start having replication issues.(It will take anywhere from 3 hr to 6 hrs compare to 10 mins) becos of the timings the data gets replicate...more >>

SELECT DISTINCT MH.agent_id, MA.subscriber_name, MH.publisher_insertcount, MH.publisher_updatecount, MH.publisher_deletecount, MH.publisher_conflictcount, MH.subscriber_insertcount, MH.subscriber_updatecount, MH.subscriber_deletecount, MH.subscr...more >>

HI we are using merge replication and now i am getting the error message as ' cannot deliver inserts to the publisher'...more >>

In Transaction replication, I see the option to generate a snapshot without locking the tables. However, in Snapshot replication, the same option is not there. Any reason why? Is there any way to do a snapshot in Snapshot replication without locking the tables?...more >>

hello, i am in a big hurry, because the distribution agent is not responding in a defined interval. Thats the reason for a stopped replication. How can i restart the distribution agent without manual doing. i tryed to use system stored procedure "sp_start_jobs" with the id of the distribu...more >>