Dir All, I want setup a replication system over internet. how could I do? Thanks for help. Best regards. TN...more >>

Hi! I was wondering if anyone could help me. I am going through the nightmare of having to setup transactional replication on several hundred objects (i.e. stored procs, views and tables) that have different ownership. If i set up transactional replication, by default all my objects will be assi...more >>

I have a large (2 gig) database on 1 server that the customer wants to replicate to another server in a different state. I have looked at the different replication options and wanted to use transactional, but that doesn't allow the subscriber to update image or ntext columns - and I have to allo...more >>

I repeatedly get this error in the application event log. The server is one of a two cluster that is log shipping to a third server. These event items appeared only after log shipping was started. Source: ClusSvc Event ID: 1137 Description: Event log replication queue OUTQ is full. 1 ...more >>

Hi, Is it possible to setup replication if the data in the subscriber database tables are being updated, but you do not want to have the changes merged back to the publisher? Thanks, Hillel...more >>

Our problem is the order of applying changes from subscriber to publisher and back, regarding FK constraints and parent-child relations. We have 234 articles in publication and if we take a look at table nicknames (SELECT nickname, name FROM sysmergearticles ORDER BY nickname) we can see th...more >>

Hello, I have been running into an issue where I keep getting the following error: The subscription to publication 'test' is invalid. I have added the server that I am performing a 'push' replication to within the Network Utility for an alias name due to DNS problems, but still I am g...more >>

Hi I want to shrink a database that I have that is currently being published. I have about 19 GB worth of data in about a 55 GB data file. I want to shrink the database so that the database file is about 19 GB. Is this possible to do without interrupting replication? Do I need to ch...more >>

I am trying to setup immediate update transaction replication without going thru initial sync process. I executed the result from 'sp_scriptpublicationcustomprocs' on the subscriber to create the sp for sp_msins...,sp_msupd..., sp_ms_del.., then I tried to execute 'sp_script_synctran_commands...more >>

I'm new to replication. But my problem is that I have a database on a web server that has data being replicated to it from an internal database. It seems that when a replication occurs, my permissions that I've set up on the web database gets wiped out and I have to go back and reset them....more >>

I have merge replication running with 2 servers (both W2K SP4 and SQL2000 SP3). I got no problems setting it up and it ran perfect since some weeks. But yesterday I got this error message, every time the merge agent tries to merge the data: "Failed to enumerate changes in the filtered arti...more >>

Hello, I am trying to set up transactional replication where the agent that synchronizes the subscription are at the Subscriber but I can't seem to set it to work. I get the following messages: On the server where the distribution database is: Login failed for user 'NT AUTHORITY\ANONYM...more >>

hi, i have one sql2000 server and several msde-clients, which use the merge replication. if i import data from a text file using the dts-import wizard, the newly imported data will not be replicated until i create a new snapshot and reinitialize all subscriptions. data inserts done by a ...more >>

Hello, I pretty new to the whole replication process, but I have a replicaton environment spanning over three continents and I would like to apply the initial snapshot of a large DB to one ofthe subscribers manually. I have looked in the SQL online books, but have nit found a clear s...more >>

Since the purge of my MSmerge_contents/MSmerge_genhistory, some conflicts occur, between updates that were performed months ago, and updates that were performed very recently. I'm absolutely certain these old updates were replicated everywhere at the time they were performed (some of them are ...more >>

I tried to create a complete image including SQL 2000 PE with SP3 for all my laptops. Everything it's working but when I try to take the first subscription I have problems. What I have to do after I use Sysprep ?...more >>

Hi all, I am setting up the following replication topgology for a client. The database is divided into four "classes" of table, each of which has a different replication requirement. The db makes extensive use of RI. We are using autoincrement IDENTITY keys on many tables in the db. Th...more >>

Hi!. I'm having problems trying to setup a multiple-publishers/central-subscriber replication setup. I've already contacted MSFT support, but I'm looking for alternatives. From tests I did, I know the problems would be solved if I move to a central-publisher/multiple-subscribers, but in my ...more >>

Hello all- Do merge agent processes run at the distributor or the publisher in merge replication? We currently run publisher & distributor from the same box. We are looking for a performance boost and were pondering adding another box as distributor. We run the merge agents at a high poll...more >>

I am currently doing a snapshot replication with a database that is 14gb in size. The inital snapshot is taking a few hours to complete. Is it going to be quicker for subsequent snapshots to be completed? I am trying to come up with a way to quickly just update the newest data, while still kee...more >>

Before installing SP3a on on SQL 2000 I get the following error: "Error 2758: RAISERROR could not lcoate entry for error 21423 in sysmessages" When running the following line in the replication script: exec sp_addmergepublication @publication = N'Test', @description = N'test', @rete...more >>

I have a simple snapshot replication that replicates all the tables in a database from one SQL2000 server to another. The distributor and subscriber are on the same server. The initial snapshot agent ran successfully. The (push) distribution agent also runs, but reports that there are "...more >>

Hi, I have one error which i haven't got on any server earlier. The error is: "Cannot alter table A.Table4 because this table does not exist in database ...." Waht is here strange that ther are 5 tables to replicate and table Table4 is the 4-th (the first 3 are created on the destination...more >>

Hello, I did a transactional publication, I synchronize the subscriber once a week, I do that by hand using Enterprise Manager. The first time it works fine. After a week, when I start the agent again, I get an error message, unfortunately I get it in Italian language so I try to translate t...more >>

I currently have a 168 GB database with 560 large tables that I am setting up transactual replication on. I have a different server to use for the distribution database with 100 GB drive for the data file and 50 GB of space for the log. I was wondering if anyone has had trouble with a OLT...more >>

Hello, I have Merge Replication Set up on SQL 2k with one suscriber. I wanted to remove one subscriber and then add another subscriber. What is the best & easy way to accomplish. Any help would be appreciated. Thanks -Nilay...more >>

We are considering doing transaction replication. If a table is changed in one of your publications, a column is added or a data type is changed, does this require that an entire publication receive a new snapshot and push of that data to the distributor and subscribers? Is there a quick...more >>

sql2k sp3 1 way transactional replication. Ive been doing sometesting lately that invovles inserting a fair amount of data on a pretty slow box. I use the same test data every time. Im the only user on the Publisher and the Subscriber. No processes other than the ones I initiate are runn...more >>

The repldata directory is defaulting to D:\mssql7 \repldata (whre D:\mssql7 is where sql 7 was installed) How do I change it to another drive, e.g. E:\sql\repldata I know it can be done (it's doing it on one of the sql servers I'm working on), but I can't figure out how (remember, this is S...more >>

I am running SQL Server 2000 with service pack 3a on a Windows 2003 server. I have previouly setup Transactional Replication with out Immediate Updating and everything worked fine. I then setup Transactional Replication and Immediate Updating with Queued Updating as a Failover. The setup and ...more >>

I am a remote employee, I VPN connect into my company's office Network. Let me pose the question this way I took an access database and placed it on one of the company's servers and ran the upsize wizard to create the MS SQL database I took that same access database and upsized it on my local ma...more >>

Hi there, I have this problem and I cannot figure out what's happening: I have a push transaction replication , from a SQL 7 to a Sql 2000 (subscriber).Couple of days ago it start this problem :The distribution agent will stop with these errors : "The job failed. The Job was invoked by...more >>

Can someone tell me how I would know what cloumn is unicode with a Latin1_General_BIN collation? I found this in an answerbook page about error 8646. I got this error when I was trying to disable replication. Thanks, Joseph...more >>

I have a database table with just under 200 fields. I realise this is unusual, but this is a requirement of my system and this is a normalized database! This works fine until I have tried to replicate the table using transactional replication with immediate updating with queued updating....more >>

Hi All, I enabled replication on a remote server. the syncronization would not work propperly due to slow line speeds. I spoke to Microsoft and they could not help. They recomended to turn off replication. I tried to disable replication thru SQL enterprise manager and I got the follow...more >>

We currently have one DB which contains all of the processing for 35 different customers. This 7 Gig DB currently has transaction replication to a reporting server for all read only queries. Each customer is getting large and management wants each customer to have it's own version of the ...more >>

Hi, This must be the simpelest question ever, I'm a beginner at merge replication... I'm replicating (merge) two tables with primary keys on different servers. (same database name, same tablename same columns etc) When a user adds a row on server 1, a new Primary Key is created (let...more >>

Hi All, I would like to know will the replication recontinue after shutting down of the subscriber and restart it? Will the replication be interruped? Thanks a lot for your great opinino....more >>

HI I have set transaction replication with multiple publishers and single subscriber.It runs fine with the distribution agent at subscriber .But if I try to configure to run the agent at publisher,it does not allow me and shows an error "can not run the service with nt/anonynous user ". I have se...more >>

I currently have a product server and a development server, Once a week we transfer the production database to the development database. To do this we use a DTS package that uses the Copy SQL server objects task. This works but the job in sql is always flagged as failed. After looking ...more >>

Hi,Everyone, I am now working on an application to use SQL Server's log file to do replications, but I can not find any information about the structure of the LDF file, I wonder who could help me, at least some tips. Thanks a lot! ...more >>

Hi where can i get this SQL Server 2000 Service Pack 3 rollup, version 8.00.0765. Thank you ...more >>

Suggestions: I have one SQL 7.0 server. I want to copy the database once a week to another server through an internal network. I want this to be done automatically once a week. The database size is about 3Gb large. Anyone have any suggestions? Whitepapers? Easy guides? ...more >>

Is there a FAQ for this newsgroup? I googled and couldn't find one. Is there a definitive FAQ for SQL Server? I googled and found many (:-). Does SQL Server replicate with other vendor's databases? Snapshot is good, merge is better. Is there a good book on SQL Server replication? Or good c...more >>

I want to replicate a database to a subscriber that will be used as a read only copy. The data has to be replicated as close to instantly as possible. To do this I set up a database export of objects and data to populate the subscriber, then I set up transactional replication. To verify that ...more >>

Hi, I'm in a process of trying to migrate a server (SERVER_1) running SQL Server 7 and NT 4 to a new sever running SQL Server 2000 and Windows 2003. The only tricky part is that SERVER_1 has a subscriber database (DB_1), which is a subset of a main OLTP database (DB_2). The size of DB_1...more >>

sql2k sp3 1 way transactional replication. Ive been doing sometesting lately that invovles inserting a fair amount of data on a pretty slow box. I use the same test data every time. Im the only user on the Publisher and the Subscriber. No processes other than the ones I initiate are runn...more >>

I've run across some problems with replication that appear to be related to collation sequences. My published database uses the default collation of SQL_Latin1_General_CP1_CI_AS. I suspect that some of my clients, however, are using a different collation sequence. I've been getting some syn...more >>

Hi I'm seeing some strange behaviour, this is the first time I try this setup, so maybe I configured it wrong. Setup is a central-subscriber with remote publishers. Each publisher has a publication with a static filter. I'm using merge replication with pull subscriptions. Server A (Publi...more >>

How can I look at the bcp initial snapshot before it's applied to the subscriber. Thanks, Maria...more >>

Hello - Anyone know of a way to configure an ODBC driver to be read-only? We have SQL Server database using merge replication. A user wants to import into Excel to "manipulate" data. Of course, my protests were a waste of time... I'd like to give him an ODBC driver that is read-only. S...more >>

Replicating between 2 Win2k Sql Server systems I have notices that the permissions of a stored procedure on the publisher are not replicated to the subscriber. Is this by design, or some omission on my part, John Yard UCLA...more >>

Hi, I was hoping someone could tell me how I am to replicate a database between servers. The many of the tables, stored procedures and views are owned by a user (e.g. USER1). The version running is SQL 2000. Lets take for instance snapshot replication from Server1 to Server2. Now I know that m...more >>

Is it possible to set up replication from MS SQL server version 7 to version 2000 purely using IP addresses? Or do you have to use named pipes? If IP can be used what port numbers are used as both servers are behind firewalls? Also can you select views to push? If it not possible what is the b...more >>

Hi, Is there a way to change/alter a column which is part of transactional replication. We normally do this often due to change in application and stuff like that so I would like to stay clear from deleting the published table and re-creating it again, if I can. Regards, JC ...more >>

We have 2 SQL Server machines. One has the production data on it, the other just Sits there. We tried to set up replication between the server, though our DB Schema changes as we are still in development of our product. So using Replication does not work as the Schema changes cause Errors. ...more >>

I'm after a book about Replication, not one could I find online, there's one coming out on Jan 1st by Sams publishing. is it really this hard?, or am I looking in the wrong places. Any tips on where to get one from would be greatly appreciated. Regards Samuel...more >>

Hi, I have just started getting an error with transactional replication. I have a publication containing 66 articles (tables) and am using transactional replication to provide us with a warm backup at a second site. I am not using immediate updating subscriber or anything that writes back to ...more >>

After deleting all subscriptions to a merge publication and then deleting the publication there seems to be a lot of conflict tables that are left behind. Is there any way to delete them? I executed sp_mergereplication_cleanup but that didn't do the trick. Thanks Brian...more >>

I'm having trouble with nosync transactional replication installs when using sp_repladdcolumn to add columns to replicated tables. After adding the column to the pubishing and subscribing DB tables, replication fails stating that our custom insert stored procedure expects parameter '@newcolu...more >>

Hi!. I am working with SQL Server 7.0. I had a problem with the blaster virus, and after that, the replication stoped working. I have SQL server registrations working with the option "Allow other Sql servers to connect remotely ..." activated, and the RPC service is ruinning on all the machines. ¿I...more >>

I am setting the log shipping interval to be 15 minutes, but it really takes 30 minutes. The file copies at the 15 minute point, but it does not get applied and restored until the next interval. So the data is really between 16 and 30 minutes old before it is on the log shipping target dat...more >>

I need to create transactional replication. Currently both the tables that I want to replicate are exactly the same in terms of datatypes, names and null values at the publisher end and the subscriber. However a different number of columns exist at both sides. Currently I have a regular DT...more >>

How can I beat this error? Please, help. Marcin ...more >>

sql2k sp3 Ive posted this twice before with no luck. Getting desperate. My replication setup; Local Distributor. 1 way transactional. 1 Subscriber. sp_replicationdboption 'sync with backup' is true for the Publisher and the Distributor. TLog backups every 5 minutes. I want to l...more >>

I have attempted every conceivable way to aply a snapshot to a subscriber. I am using a merge replication from a Sql Server 2000 SP2 publisher and distributor to a Sql Server 2000 SP2 subscriber. I attempted by delivering the snapshot automatically after its creation and manually. The merge re...more >>

Does anyone know were the retry attempts for a job are stored? I have replication agents that are set to retry 10 times. It seems to me that these are stored somewhere because they will sometimes fail after 1 or 2 retries, saying that the job has tried 10 times. I am looking for a way to r...more >>

How can I replicate from one server to another when the only way they can see each other is by IP. WHen in SQl manager I can register teh server but by IP only. THus when I try to pull the subscription it tell's me It can't do it by IP Any thoughts?...more >>

Hi all, I tried to restore a backup from a replicated database and I got the following error: "The index entry for row ID was not found in Index ID 2, of table 1312723729, in database 'BR19Nancy'." the table reference here is MSmerge_contents and I do not see an index 2 here or on my replic...more >>

Is it a better strategy to have one large publication of 30 tables? Or break it up into 10 smaller publications of 3 tables each? I am considering the size of the snapshot and the length of time to rebuild in case of a problem. Any advice?...more >>

I have created a snapshot replication for a database. I want to alter a column of a table. As i cannot do this when replication is set, i have dropped the replication and fired the a sql for altering a column of a table using 'alter table employee alter column empname varchar(50)'. It is giv...more >>

I've got some replication setup between live and staging SQL Servers. Although this was working correctly, I've noticed error messages over the past few days that this job is failing. If I open the job history, there are hourly entries for the following: "The job failed. The Job was i...more >>

Dir All I have a problem in replication First, I create a replication between 3 server: DB1 (pubblisher, Distributor), DB2, DB3(Subcriber) - DB1 connect to DB2, DB3 by dial-up. - I run SLQserverservice, SQLserverAgent at DB1 with Administrator user of WIN2000 server - replicate successfully ...more >>