I have three questions?? 1. I have a Sql server instance running without any name, it just has a default name (local), when i try to go configure replication its says that replication does not support (local) name. This server is in production right now. And it will be hard to shut it down. ...more >>

...more >>

We currently use log shipping as a means of reporting for users to query off of on the secondary hence eliminating ad hoc querying on the live OLTP server Problem with log shipping is obvious..Users are kicked off when logs are being restored. So if we do use replication for each and every ...more >>

Is it possible to configure a linked server to be a replication publisher in sql server 2000. I have a progress v9.1 database that is configured to act as a linked server that I would like to make a publisher and then use a sql server 2000 subscriber. Thanks!...more >>

I'm a little confused. I've been working on setting up one snapshot publication for one DB, and one "one-way" transactional publication for another DB (both on the same server). My three "client" subscribers are running MSDE 2000 SP3, and they are subscribing to these to Publishers. As I...more >>

Hello all, I am seeing a rather odd replication issue, thats new to me and I was wondering of anyone could provide insight on how to resolve it. I have several SQL servers (SQL2k w/ all patches and SP) replicating several databases via a transactional replication. There have been no ...more >>

HI NG, on a testserver mssql2k I have one publication with NO subscribers backup LOG .. fails: The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as distributed. ...more >>

"The process could not deliver the snapshot to the Subscriber" I added a new database to the same server as the publisher and distributor. The error ocurred when pushing a new subscription to it. I did indicate that the subscriber already has the schema and data. Any ideas for correcting?...more >>

I need to learn the steps to investigate which transactions are not getting replicated, thus causing my log file to grow. I periodically check the dbs I administer and wait until after hours to force replacation done using sp_ReplDone, followed by a backup and shrink, for those dbs with e...more >>

Is there any way to add columns to the database and not have to stop replication. I have one publisher with many subscribers and I don't want to delete all the subscriptions to add columns to my publisher. If this is not the correct way to add columns could you please explain how I shoul...more >>

Hi, I have configured Log shipping in my organisation which has two forests. One forest has primary server and monitor server while the other forest has secondary server. While configuring the Log shipping, read only database was created successfully on the secondary server. Primary server ...more >>

Environment: Central SQL 2000 db (with SP3a), employing 3 Merge Publications with column level tracking 240 distributed/disconnected subscribers using pull subscriptions running MSDE 2000 We're having a high volume of suspect databases appearing. Causes are varied but the majority are tor...more >>

Please, send me link approaches types of replication. I need install this resource. I have a problem with my remote network and consider that is solution. ...more >>

Hi, i want to change the Transactional retention time in a pull subscription replication.my question is can we can retention time to avoid deactivation time without reinitializing the subscription? thanx in advance regards amir --- Posted using Wimdows.net NntpNews Component - Post Made...more >>

I have two databases Im testing a replication setup on. PrivateDB and PublicDB. Both the database schemas are the same and I have on table in them called CostInfo --------- ID int Cost money Description nvarchar(500) 1) I want to setup bidirectional replication between both these d...more >>

I am trying to set up Transactional Replication and here is the configuration. Server1 - Publisher Server2 - Dist Server3 - Subs Since the database was huge so I ended up making a backup from Publisher and restored it on Subsriber. When I was setting up Publication using EM, I Set up Arti...more >>

I am trying to complete a distributed query on two seperate sql instances, two seperate databases, two seperate tables. I am trying to do an insert from one database to the other when an insert occurs in the originating database. I have attempted both a trigger running the sql query and a trig...more >>

Dear all, I got the following error while doing the replication in updating the date, I found that a column's datatype is NTEXT, but i have other table also are have columns set to NTEXT datatype and it works. Does anyone have any idea on it? "Only text pointers are allowed in work tabl...more >>

Dear group, in the SQL-Server documentation it says: "Merge replication supports the replication of text, ntext, and image columns only if they have been updated explicitly by an UPDATE statement because it causes a trigger to fire that updates meta data ensuring that the transaction gets pro...more >>

Hi NG, In sp_repltrans I only get the xact_seqno but not the command text. How can I get the command text (like in sp_browsereplcmds)? Regards Thomas ...more >>

Hello I have a question. We have a merge replication between 4 servers and it's working fine but we had a conflict while deleting a record in a master table wich has the location and product as a key that says : "The same row was updated at 'servername1.replication' and deleted at 'servername...more >>

I have 2 servers replicating two way, using merge agents. i want to receive a notification(via email preferably) when the merge = fails(the notification would run on one server only, the one with the = merge agents), but haven't found a clue on how to make this work. Any ideas are greatly ap...more >>

Jim this means that I should PUSH the subscription again ? will be lost the data generated at the at the subscriber ?...more >>

I am setting up transactional replication and only want to replicate three table but want ALL tables to be in the inital snapshot. How do I do this? I choose the three tables I wanted as articles and when I initialized the first snapshot, only those three tables went over. I would like all ta...more >>

I need to drop a few publications because they are located on the wrong hard drive on the server. Before I republish these databases can I delete the metadata tables? I would assume that if the publication is dropped then the metadata tables become meaningless, is this correct? Which tables ex...more >>

Hi, I m wondering if i cud change Trasactional retention time from 72 hours to 200 hours without reinitializing the pull subscription which i am using on my offshore server. can i change it ? regards AmirSaifi --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.S...more >>

i would like to know how to create a new instance of sql server. i am using a program that i have to duplicate the database while it is blank/emply and be able to connect to either database from workstations. i dont know if i am using the correct terms but that is what i need to accomplish, any ...more >>

how can i make a replication between SQl Server 2000 and Oracle 9i *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

This topic has probably been pounded to death, as I've read a considerable number of posts, yet I haven't exactly found the answer to what is going on in my situation. I've got SQL2k running on a Win2kPro box. When I try to create the snapshot folder -- regardless of which folder I use (eve...more >>

Hello, I want to move the database files to another disk drive, from C: to D:. The database is being replicated, so I cannot just detach it. Can anybody suggest a way to do it without recreating of 200+ subscriptions? (I'm using SQL Server 2000, SP3a, merge replication) TIA, Igor ...more >>

or will their sql machine already know to extract the cab file and put it where it needs to be. Thanks, comb...more >>

I have created a merge publication where the subscribers are dropped after 1 day. I believe this time period is also serves as the "retention period" for metadata in msmerge_contents. Publisher version: Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Subscr...more >>

Hi, I have a trigger that is running a distributed query to perform an insert into a linked server. The trigger is executed up insert into my table. When I execute an insert through the query analyzer, the process becomes locked both in my local database and it's linked server. This caus...more >>

Hi - I have a question about how Alt. Partners work. I have a scenario where A is a publisher and B and C are subscribing to A (pull subscriptions). Now I want B to be an alternate partner so it can synchronize with C. So I make B a publisher (which is identical to A), then I subscr...more >>

I am delivering replicated data from a t3 connection to a t1 connection.. My ping times to the subscriber are pretty good.. about 40ms consistant. I have the following rates that seem to be really slow for distributor/subscribers on such good connections. delivery rate (cmds/sec) = 212...more >>

Hey everyone, I have a nasty replication scenario in my test and QA environment that I am trying to deal with. I have a database replication scenario that goes like this. production_db get replicated (transactional) through a dedicated distributor to a reporting_db. I have to cleanly pus...more >>

I'm trying to setup a program that will create a snapshot on a server and then after the snapshot is generated I want to sync the local database with the snapshot. Whenever I run the program to create the snapshot it will fail with the following message: The process could not create file '...more >>

Hello, I am getting the following error when trying to sync from my local site to my dr site. Could not locate entry in sysdatabases for database '10.1.200.70'. No entry found with that name. Make sure that the name is entered correctly. (Source: 10.1.200.70 (Data source); Error number: 9...more >>

Hi. I've asked about this before but didn't get an answer. Due to problems in the replication with SQL CE devices I found that the merge agen parameter "-ForceConvergenceLevel" probaly could help solving some of those problems. But where to put it? Normaly you would right-click the merge ...more >>

We have snapshot files ready on cd , due to some reason connection between subscriber and publisher could not be establish, so how can we merge the data to subscriber through cd or removable media. please advice thanks Fatiya ...more >>

for example: I am publishing about 5 tables to one subscriber. Each table is approx 10gb each. I want to break them up into 5 different publications in case something happens to one of them and I need to reinitialize. I figure If i had to , it would only need to reinitialize that 1 1...more >>

I'm setting up my first subscription, and I keep getting the following error on the subscriber: The schema script '\\MACHINENAME\ReplData$\unc\MACHINENAME_security_security\20041026153509\pe rson_1.sch' could not be propagated to the subscriber. Any ideas on where to begin troubleshooting. ...more >>

I have two SQL 2000 Servers with Merge Replication. I had a problem on my link for a month and the "Expired subscription clean up" job dropped the subscription ! and now I don't know how to replicate the generated data at the subscriptor. I appreciate any help. ...more >>

Is it possible to replicate Store Procedure ? Because I cannot found the article for is, does anyone try it before? --=20...more >>

Dear all, my question is show As Title, please help --=20...more >>

Hello all, Have been searching for a solution to this problem for several days now, all to no avail, so hopefully someone will be able to help. Using Transactional replication on SQL Server 7.0. Multiple subscribers which subscribe to multiple publications on a server set up as publisher...more >>

Am using bcp to upload data files to sql server. The data file contains some duplicate values. So I used something like ">bcp pubs.dbo.stores in "stores.txt" -m 50...." assuming, the bcp stops only after encountering more than 50 duplicate. But BCP stops whenever it encounters the first duplic...more >>

Hello Group, We are running transactional, anonymous pull subscriptions, all SQL Server 2000 SP3. We recently moved our distribution database to a dedicated distribution machine. Since then our subscribers have not been able get new articles without dropping and recreating the subscription...more >>

I have recently been the lucky recipient of taking over two SQL Servers running Windows 2003 Server Standard, and SQL 2000 Enterprise. The employee working on these servers had a bad exit and I am doing the cleanup. I want to setup log shipping between db01 and 02. I have everything in ...more >>

> Hello, > > I get the following error: > > > > Server: Msg 11, Level 16, State 1, Line 1 > > General network error. Check your network documentation. > > > > > > Need help. > > > > I have 2 sql server instances on two different machines. > > > > Created a linked serve between SERVE1 and...more >>