I have been asked to set-up replication in the current two server enviornment. My understanding is that Log-Shipping requires the Enterprise version of Sql Server 2000 (Which they do not have the budget for). They have 70 Databases that have a total space of aprox 30gb. They wan...more >>

I have set up six push subscriptions of the same publication on a wide area network successfully, but am having a problem with the seventh one. I think the problem is due to the fact that the subscription was set up using the subscribing server's IP address rather than network name (there is c...more >>

I have a copy of a database "db_A" called "db_copy". When I try to alter tables in the database, it complains that it is being used for replication. It is not being used for replication, but the database that it was copied from is. Is there anything I can do to allow us to alter this datab...more >>

One of our critical databases that is part of a log shipping-like set up is corrupt. This happened while doing a full DEb restore. DB was showing status 'Loading/Suspect' for about 5 hours. However, restore job has failed, and nothing is attempting to restore it. I am unable to get get any ...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. Bo...more >>

I have some tables in a database that is tranactionally replicated to another server. Each table has a column which is the primary key as well as having the Identity property set to Yes. The subscribing table has the same settings for the corresponding column except that Indentity is set to ...more >>

I adapted Hilary's DMO Example, and have tried ReplCtrl\VB\ReplSamp.vbp ... WHAT CODE DO I NEED to .Initialize .Run .Terminate the SQLMerge? Subscription was created using Windows Synchronization Manager, Administrator Account on WinXPPro Laptop. VB is running in MS Access XP Runtime...more >>

How can you make an Access database a subscriber to a replicated SQL Server database? We plan to have a database on the server, and Access databases on remote users PCs to access the data, but until I can work out how to synchronise the data we might as well not bother...more >>

We have configured transactional replication with queue updating subscriptions. The publisher/distributor on serverA pushes a small db publication to the subscriber on serverB. When both the publisher and subscriber are continuously connected, modified data (on either server) is replicated bac...more >>

HI I am trying to design merge replication. step1:configure sqlservr1 as publisher and distributor and published pubs database. step2:from sqlserver2 i tried to pull the data using pull subscription.everything works fine. step3:again i decided to disabled publishing then start disabling s...more >>

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