Do any one know how to detect a distribution agent failure thru program. Is there any way to start it programmatically. Any help would be great...more >>

When I synch my subscriber back to my maste. A record I created on the subscriber is now on the master but it is not also on the subscriber like it should be. Any ideas? Everything seems to be in order. ...more >>

I have started merge replication. It was working. Now I get messege that 'The process could not deliver update(s) at the Subscriber'. If I start it manually, I see message come it has down loaded some records. 100 update, 1 insert etc. I can see my CPU usage is 100%. Then after few min late...more >>

We currently use Sybase's ASA software to provide local databases for network disconnected access to about a half dozen home grown applications. Does MSSQL server have a desktop version (running on Windows 2000) that can be synchronized with SQL Server 2000 running on a back end server to pro...more >>

SqlSvr 2000 on WXP Pro All on a single server, is it possible to setup one database to replicate to another database ? SEM > Replication (right-click) > Configure Publishing, Subscribers, and Distribution ... > proceed through the wizard accepting the default choices, get the error: ...more >>

I have several errors that I have set up for SKIPERRORS. This is so I can just get the snapshot to apply without stopping everytime it hits an issue. Unfortunately, when an error is encountered and skipped, it lists the command id as zero... I need the agent to skip the error but ALSO tell ...more >>

Does anyone know of abbreviated T-SQL that would sure-fire delete a set of databases that participate in replication ? I would like to do this without writing T-SQL to -- Drop the transactional subscription -- Drop the transactional articles (every table in publication database) -- Dro...more >>

Is there anyway to modify indexes also permissions on replicated tables for SQL2000 Transactional replication. Every time snapshot agent runs and refreshes the table all of the indexes are replaced from source table and also permissions ...more >>

we are replicating a table in sql 2000, all seems to be going well, but there seem to be twice as many tables in the subscriber database than on the publisher. For Example: there is talble f0092 that has the owner as dbo & sys7334. This is the case for each single table, thus my database on th...more >>

Hi, I have a problem regarding the filtering on a merge replication. I have a complex Customers / Products database. Each subscriber to the publication belongs to a sales region. The idea is to have the data filtered down depending on the sales region so that the sales team only have t...more >>

Dear all, i had a table named saletable i had fields like itemgroupid,itemgroupname,saleqty,saleamount and saledate. i want to sum the saleqty and saleamount by every month and year.but i dont want to eneter the date every time means no user criteria. for eaxmple itemgroupid item...more >>

I have a laptop user that gets a merge timeout error when she attempts to merge. This is an intermittent error and she was able to successfully merge when she retried. The replication process uploads her changes to the server successfully. It then downloads changes and while iterating th...more >>

Hi, I have only a pair of mdf/ldf files for a database, and want to recover = to a new instance of SQL Server 2000. Please advise the procedure to = perform this. Thanks a lot, Jake...more >>

Hi all, I have a backup of a repliacted (Merge) database (SQL Server 2000). What are the setups of restoring this merge database to a new server. Please provide me with detailed steps on how to do this? (I have restored this database the MSDB and Distribution database but it did not work I ca...more >>

Hello, every few days my merge replication fails due to a network problem and subsequent time out. How can I trigger a replication restart automatically, or at a certain time of day?...more >>

I am setting up replication for the first time and, as can be expected, running into problems. The scenario is a server in one domain that will be a publisher using a remote distributor in a different domain. When trying to configure the publisher server, I keep getting a 'server does not exis...more >>

sql2k sp3 win2k sp4 Im trying to create a Pull Subscription for replication and get "Error 8198: Could not obtain information about Windows NT group/ user 'domain/ user'". I read this: http://support.microsoft.com/?kbid=834124 But both boxes are in the same domain and the same subnet. B...more >>

I have a merge replication set up with a SQL 2000 publisher and an MSDE subscriber. We are at a point where we are considering upgrading the MSDE install to SQL 2000. I know the install/upgrade process is relatively simple. Are there any precautions or issues with replication in upgrading from...more >>

What are the pros and cons of using SQL vs the CALL,MCALL,etc. stored procedures to replicate data in transactional replication ? ...more >>

Can anyone tell me how severe this error is and how to fix it? I have received this error twice now within the month. The database seems fine and replication continues at the next scheduled time without error. Error: 14151, Severity: 18, State: 1 Replication-agentclassname: agent dti000s...more >>

What is the proper T-SQL to remove a database from replication? Specifically, I want to duplicate the following SEM sequence : Replication (right-click) > Configure Publishing, Subscribers, and Distribution ... > Publication Databases > {database name} > uncheck the Trans checkbox ...more >>

sql2k sp3a The configuration is currently. Box1-- Publisher/ Distributor. Several Subscribers all with Pull Subscriptions. One of these Pull Subscriptions that my boss wants me to start Replicating from. Can this type of deal cause problems? TIA, ChrisR ...more >>

Hello, I’m having a strange problem with sql entreprise manager… I have a Sqlserver registered in two Entreprise managers in two different computers. Both are registred with sa login. In PC one, in the window “Publisher and distribution properties”, I can see 4 tabs: Distributor, P...more >>

Hi, I am dealing with 15 databases, all are merge replicated with remote server(publisher). Daily, the Datafile size is noted. For a particular database, from 04/01/2005 to 04/22/2005 the datafile size 1.37 GB. But on 04/23/2005 it is increased to 1.50 GB The DB property : Automatical...more >>

Hello How can I create a database backup when is used in merge replication ? Can I use simple BACKUP database dbA procedure ? ( AFAIK it is working when restoring to database not used in replication. ) How about restoring when merge replication is used ? Do I have to use KEEP_REPLICATION argu...more >>

Hello i'm using merge replication in SQL server 2k but when i try to synchronise a subscriber i get the following error Cannot insert the value NULL into column 'rowguid'.... This seems to be caused by the fact that the columns are in a different order ie. columns we added after the public...more >>

Hi We have an access app (front-end+backend) running on the company network. I am trying to setup replication for laptop users who go into field and need the data synched between their laptops and the server upon return to the office. I am planning it this; Move all access tables to sql ...more >>

Hi, I have a publisher with some Pushsubscriber. The replication type is merge. And some tables have user defined triggers. When a user insert, update or delete data the triggers will be fired, but when the merge-agent kopies the data from the publisher to the subcriber the the triggers will ...more >>

Why would sp_replcmds take more than 1 hr to execute ? I know its tied to the log reader.. Can you point out some reasons why it may do so ? ...more >>

When one replicates an indexed view, its just the definition right ? Im trying to understand indexed views and how it would tie to replication.. I know theres execution of stored procs that can be replicated. Does indexed views have something in that fashion ? I guess i dont understand indexed v...more >>

Does the distrib.exe make a connection to SQL and read all the trans/commands from the distrubution database to push to the subscribers ? ...more >>

Hello, I am researching solutions to a problem I have and was wondering if anyone could recommend a tool that might help me, or had any other ideas about how I might go about addressing the issue. I have a legacy SQL Server 2000 system (with transactional replication enabled) and a ...more >>

I tried to find similar information from the web and the user groups about our replication issue, but no luck. Wish you could help: We have a sql7 (version: 7.00.1063) on a Windows NT (sp6a) Server box A, it replicate (act as distribution server as well) some data from some tables to ot...more >>

Hi friends, Recently i configured merge replication with pull subscriber the snapshot agent ran successfully but merge agent failed(never started)raising the problem . any help would be appriciated. -- Message posted via http://www.sqlmonster.com...more >>

sql server enterprise manager could not start merge agent error:22022 can any one tell the solution for this would be appreciated. -- Message posted via http://www.sqlmonster.com...more >>

How do u check for replication latencies or if say the log reader or distribution agent has stopped due to some failures ? Is there an easy way to track this without buying some 3rd party tool. How can one write a query ? Love to hear some of ur ways of detecting delays in replications.. ...more >>

When trying to add an article back to an existing publication thats active in transactional replication I get the following error Server: Msg 14100, Level 16, State 1, Procedure sp_addsubscription, Line 240 Specify all articles when subscribing to a publication using concurrent snapshot proc...more >>

Hi, I have a test database. In case if the database is corrupted, how can I retrieve the database. I heard that using log transaction files we can retrieve the DB. But I don't know how? The DB is in Simple recovery mode. I want to know how can i recover a corrupted database? and delet...more >>

I know ive asked this before and created seperate publications for tables and views,etc in order to avoid conflicts such as view being created before the table,etc.. What do u guys prefer as the best method to handle this, especially if reinitialize a publication that has tables in it and it r...more >>

...more >>

.... what would happen ? Using trans replication ...more >>

I have mysql running on a windows2003 webserver - it runs a messageboard and oscommerce. Potential new client wants to replicate information from the website to her server - is this possible with mysql or do I need to install sql (proper) ... sorry if I sound like I don't know fully what I am d...more >>

Hi I have just converted an access mdb app to an access adp app with msde backend. I am very new to sql server. My question is how do I create replication for a few laptop users who would like to take away the app for a few days and when they come back would like all the new data (laptop & se...more >>

If i want to inquire about the outstand transactions before i sync. what kind of info can i pull out form the merge agent/or where to get this info..say i want to know how many deletes did i do in this replica before i decide to sync... is that possible programatically? ...more >>

Hello everyone, I am a newbie on replication, I attempte to set up Transactional Replication with remote distributor between 2 servers (Server1 as Publisher and Server2 as Distributor and Subscriber). From the Configure Publisher and Distributor wizard, it indicates distributor was properl...more >>

Seeing this in the status of " 1 transaction with 800000 commands were delivered" seemed quite a lot. I know we have modified our distribution agent profile to 1000 commit batchsize and commit threshold. How does the calculation work ? Also does it mean that theres some contention especia...more >>

I've looked in BO and can find nothing on this. How long do errors stay in the MS_replerrors table? There were rows in there last night and now this morning the're all gone...I was hoping to retain them in order to track down some issues. How can I change theretention period? ...more >>

My merge agent is getting stopped at midnight. because of which i have large number of records which needs to be merged when i come in the morning. Is it possible To create a job which will run every 3-4 hours, which will check whether the merge agent is running or not? If the merge agent is...more >>

Hi all, I have set up MR to sync data between Pocket PC and SQL Server 2000. It runs quite stable for months. But recently , I met a strange problems. Problems description: -Normally, size of DB about 60-75MB.Pocket PC Users will do sync with Server daily. -Database on server not change much...more >>

Hi We have an access app (both front & back ends are in access) that runs over win server networks. There are now more and more users who would like to take away a copy of app with them, work offline, and when they come back expect the client copy to sync (both ways) with the server copy. Seem...more >>

Hi, I have 150 tables in a database. Composite primary key is used in some of those tables. Can I list out the table names having composite primary key. Thanks, Soura...more >>

Hi, I'm totally new to Replication. I'm reading the whole mornign alreaddy docs and pages about it, but I still don't know how to solve this situation: My (new) company has different Production-Sites, and one Main Office. All of them have a copy of an Sql Server 2000 Database. One or two tim...more >>

Hi all: Just doing research on this topic, how many other tools can doing replication with sql 2000? What i mean is that i setup replication in my sql 2000 , then other tools can download database throught by interent . Thanks Nick ...more >>