Hello, I want to setup SQL Log Shipping btwn two servers. - Do the servers have to run same version of Windows? Can one be Win2003 and the other Win2K Server? Or one Win2k Advanced and one Win2k Standard Server? - Do I have to run the same version/build/ServicePack of SQL Server? many ...more >>

I've been having a hard time finding a definitive answer about merge replication and any sort of latency on a transaction between a subscriber and publisher. I apologize in advance for the lengthy post, but it's difficult to really "cut to the meat" of this one :) Here's my scenario: I'm ...more >>

I have the following problem with merge replication (hoping I can put it down in a clear, probably not concise, way). 1) We have a merge replication setup between a publisher and a subscriber. 2) I have set up the subscriber in such a way, that at initialisation, it al ready had all schema i...more >>

Greetings: I have a situation where I need to replicate somewhere between 40 and 80 databases between two SQL Server 2000 clusters. I've already built a 40-database set of transactionally replicated items as a test (I should mention these are fairly complex databases, with about 850 tables,...more >>

I took the following from BOL... Replication->Planning for Replication->Evaluating the Replication Env-> Planning for Application Development "A table used in a merge publication can have a maximum of 246 columns and a maximum row size of 6,000 bytes" Is this true? Whats the actual impa...more >>

I am trying to setup a server to be enabled for replication. It is a SQL 2000 Sp 3a server. The error appears at the end of the wizard as it stepping down the entries setting up replication. It gets to configuring Distributor and then gives the following error and then drops the distribtuion d...more >>

I need to build some custom replication trouble shooter and I can't find answers on couple of questions. - How to determine status of command in MSrepl_commands? I mean status is delivered this command to subscriber or not. - How long delivered transactions reside in MSrepl_commands? ...more >>

i got 8 databases published now i need to make a copy of database 1 to database 2 is there away to do this without breaking the replication? ...more >>

Hi all, I need your help. My problem is about bulkcopying data from publisher to subscriber in merge replication. In my publication there are 174 tables, most of them have timestamp column and some of them have text columns. The Error I get is : source name :ODBC SQL Server Driver error ...more >>

Hello... I have a stored procedure that is failing to insert into a table. When I manually run the INSERT statement in SQL QA, I receive the following error message: "Server: Msg 208, Level 16, State 1, Procedure ins_C5257449520A4EBDBDF3BBA9F8C9F40E, Line 29 Invalid object name 'tsvw...more >>

I was doing a routine check in EM of the publication properties for the merge replication scheme I have and found that there were no subscriptions listed in the Subscriptions. They were there last week, and replication is still running without errors. Can anyone tell my how this happens? ...more >>

When log shipping is setup, does it truncate the transaction log when it is copied to the shared folder to be send to the standby server? We currently have a prod database that generated about 30 Gig of transaction logs a day. I have a log of 20 GB and I setup an alert that fires when the ...more >>

Over the weekend the IT infrastructure guys changed the domain name on all our servers. Replication is now failing with a "The agent is suspect. No response within last 10 minutes". Both the Log Reader and Push subscription have this error. The SQL Server agent seems to be fine. I hav...more >>

How does merge replication work when you have a summary table that is affected by triggers? For example: a chart of accounts table that has balance information updated from triggers on a transaction table. ...more >>

Hi, Does anybody know what exactly this MSdistribution_status column mean? Is it number of commands that have to be delivered yet, or number of commands in MSrepl_commands that aren't delivered because of some error? Thanks...more >>

I'm developing a setup package for an application that involves some replications. I create the new replication database, transactional publication, merge pulication and a pull named subscription on the rtansactional publication. For checking that the snapshots have been generated successfully ...more >>

Hi, I configred bidirectional (not important for this issue) transactional replication. It was working fine few months, but suddenly, distribution agent on one end of replication (just for one publication) stopped working: Transactions are delivered by log reader agent to distribution dat...more >>

Hello, We are just in the design mode of setting up replication. We have 3 sql instances. 2 of the instances are setup for pull subscription to the 3rd instance which is located at corporate. The remote 2 instances generally have about 5x the amount of new data entered opposed to the ma...more >>

We have a operational system on AS/400 and a reporting system on MSSQL. I would like to replicate some of the table on DB2 to MSSQL. Of course transfering all the data with DTS takes a long time. I even parameterized the DTS packeges with a year to tranfer only the data of this year - most of th...more >>

Hi, I had configured merge replication with pull subscription. the server has installed win2k sp4 with sql2000 standard edition sp3. The server had hardware problems, so we have to reinstall all the server. Before that I get a script for all merge replication. After the reinstallation, I run a...more >>

I have a problem with my Merge Replication. It gives no errors and runs fine for most of the day, but there are times when new records do not get sent to the subscribers. I have two subscribers one on the East coast and one on the West coast. The east coast one will work reasonably well and wi...more >>

Hi There, I have a problem. I want to establish a merge replication (Please note it is not just push or pull) between the computers of a non-trusted domain. I have a firewall D-Link 808 between the two computers. One of my PCs say PC1 has SQL Server 2000 and PC2 has MSDE 2000 SP3A. Althoug...more >>

Are there any routines out there that will automatically convert a table (A) with numerous numeric fields to a new table (B) with just one numeric field. Thus the number of records in the table (B) would be the number or records in A mutliplied by the number of numeric fields. Thanks in advan...more >>

Using transactional replication and wanted to know if we change the recovery model from simple to full or vice versa while replication is in place, does it break anything ? Using SQL 2000 Thanks ...more >>

When trying to replicate I get the message "Another merge agent for the subscription(s) is running." Both publisher/distributor and subscriber are SQL2K SP3. There is no orphan process for the agent in the sysprocesses table. I monitored the sysprocesses while the agent is connecting: for few s...more >>

hi all, I heard that default exchange type for Merge Rreplication is bidirectional, or declare explicitly via editting Run Agent, -ExchangeType 3. I have tried both ways but data in subscriber is not uploaded to publisher !!! Could anyone tell me why? FYI, our model is: Publisher and Dist...more >>

Hello, What is the best method of adding a check constrain and default value to a column that is participating in replicated?...more >>

Bonjour, I'm trying to write a script that would notify a remote admin that their server(subsccriber) has not replicated with the publisher in a specified amount of time. I can manually view the the 'Merge Agents' in SQL enterprise and see who is falling behind. According to HELP the tabl...more >>

I didn't create this database architecture, but I do have to support it. The Master server is SQL200 on Win2k and is the Publisher. The Slave is SQL200 on Win2k and is the Subscriber and Distributor. The merge agent fails b/c of a deadlock error on the Master. At this point, I usually have ...more >>

I need to add few new colums to a db that is a publisher in replication. If i add these colum normaly (alter table add column) they wont be in their table article and to add them to the subscriber side I'll need to recreate the replication. I remember their is a spesial SP to add the column so th...more >>

I want to create snapshots (read only) on SQL server that pull from an odbc data source (mysql db). tables are small and a full refresh is acceptable....more >>

We have created a transactional replication in SQL2000 sp3a that runs on a on demand basis (we trigger the job to run when we want to update the other servers). when the job is submitted through EM or by starting the agent through Replication Monitor the job runs as if were setup to run continu...more >>

I am looking into work-arounds for what seems to be a flaw, or "undocumented feature" of SQL Server replication and Instead of Delete triggers not playing together. It seems that if you want to use replication then you cannot use Instead Of triggers as it prohibits the replication triggers from ...more >>

I have a current merge replication system with a publisher server that is its own distributor, and four remote subscriber servers. I now want to make the present publisher/distributor a distibutor, and add a new publisher only server. What is the easiest method? Can I avoid having to recreate...more >>

I have recently migrated our SQL7 DB to a SQL2000 server (Standard Edition). We now have an additional server with which to do reporting. What I am considering using is Transactional Replication to (as often as possible) move data to the reporting server. However, I am wondering what the ea...more >>