I have several subscribers to 3 merge publications on my distributor. I have previously put one script out on one of my publications...

Steve

10-26-2009 01:24 PM
Steve

We are currently replicating a database (70G) from SQL 2008 std (server A) to SQL 2005 std (server B). We are using transactional and push method. ...

OceanDeep via SQLMonster.com

10-21-2009 12:57 PM
OceanDeep via SQLMonster.com

Using MSSQL 2005 x64 enterprise. I understand that increasing the Max Text Repl Size will increase latency in replication, but is it the setting...

Steven

10-20-2009 06:39 PM
Hilary Cotter

Hi all, I've implemented a trasactional replication. Let's say that I have a table wich name is "TABLENAME" that I have to replicate accross some...

Andrea Caldarone

10-19-2009 02:13 AM
Andrea Caldarone

I have a requirements to setup 2 SQL servers, and replicate databases between them 'but' allow changes to the tables, views, stored...

Mike 'Spike' Lovell

10-17-2009 10:49 AM
Mike 'Spike' Lovell

Working on a scale-out architecture for our main db. There are some tables that have basically static data that should be the same in all the...

mEmENT0m0RI

10-14-2009 04:56 PM
Paul Ibison

Hi all, hope to post in the correct group. I'm looking for a solution to replace our old Access data file with SQLServer installation. Now i need...

SteM

10-14-2009 04:51 PM
Paul Ibison

Hi, For a Architecture / Infrastructure technology quote to get a job, I need to pull together some info on Replication Engines....(Only one I know...

prince1099

10-14-2009 04:49 PM
Paul Ibison

We have a merge publication with push subscriptions to subscribers. The merge agents are configured for continuous...

Bart

10-14-2009 04:41 PM
Paul Ibison

I got this error when i'm trying to execute a merge publication.. Request to run job SERVER-factu23-Maestros_Factu23-POS \SQLEXPRESS-1 (from User...

Investigacion Desarrollo

10-12-2009 10:29 AM
Paul Ibison

I am looking for a SQL 2005 Replication Presentation that can be sent to an IT Team. It does not have to be a step by step guide to setting up...

LPR-3rd

10-12-2009 10:25 AM
Paul Ibison

Hi all, I've two servers, let's say old_one and new_one. Both have SQL Server 2005 SP3. On old_one I've several database, some pubblication and...

Andrea Caldarone

10-12-2009 10:19 AM
Paul Ibison

Greetings, I believe I'm running into a limitation of INSTEAD OF triggers, so I'm posting here in case anyone has found a solution for this. Here...

Sam Bendayan

10-08-2009 01:12 PM
Sam Bendayan

I have two servers in merge replication. Each article is given the same conflict handling stored procedure which selects the successful result...

rocket salad

10-08-2009 09:27 AM
rocket salad

Hello, I have the following problem: I have added a new article (table) to a merge publication on SQL 2005 STD. For some reason, every time the merge...

Tom

10-07-2009 02:41 PM
Tom

We are currently have merge replication (1 publisher and 1 subscriber both on SQL Server 2008). We have some tables that are not part of the...

Toni

10-07-2009 04:36 AM
M Azim

Hello, I have the following problem: I try to add a new article (table) to a merge publication on SQL 2005 STD. I have generated the new snapshot and...

Tom

10-05-2009 12:58 PM
Eduardo

I am trying to make a reasonably good prediction about whether or not a particular amount of bandwidth is adequate for a remote site. Among...

Tony Vrolyk

10-05-2009 11:30 AM
Tony Vrolyk

Afternoon all I have a question. Currently we have a 'log' table that we use to store messages that we present back to the user showing most recent...

Ron

10-05-2009 06:15 AM
Ron

So this article says to not use it, will be removed in future version http://msdn.microsoft.com/en-us/library/ms152488.aspx How the heck am I doing...

Chris

10-02-2009 07:52 AM
hilary

SQL2005 Std Ed / Win2003 Server on Pub/Distr/Subscr(5) I have about 29 tables in merge totalling 15Gb of data. Too much to init to our remote...

Chris

10-02-2009 07:51 AM
hilary

Hi all, I've a published database with a published table dbo.Item. I don't publish all columns in this table: dbo.Item primary jey ...

Andrea Caldarone

10-01-2009 04:19 PM
Chris

We have two SQL 2005 servers that the second one is strictly for failover; however, I would like as much as possible on the data replication to...

pcnet

10-01-2009 04:15 PM
Chris

I would like to know the proper way to replicate only the most recent one month of data. My situation is that I have a master copy of our database...

Jay Chan

10-01-2009 11:57 AM
Jay Chan

I've got an MSSQL 2000 publication, being subscribed by a single MSSQL 2000 subscriber. The front end application made an insert to a User table at...

Joseph

09-30-2009 04:31 PM
Laurent Bouyssou

Hi, Why SQLServer 2005/2008 add a rowguid tables published as "Download-only to Subscriber, prohibit Subscriber changes" article ? My understand is...

Laurent Bouyssou

09-30-2009 02:52 PM
Laurent Bouyssou

Hi All replication gurus, I want to resync replication using backup and restore, instead of using snapshot. SQL server 2000 sp3 to sqlserver200...

Nik

09-26-2009 12:51 PM
Paul Ibison

We have SQL 2008 using merge replication on selected tables, views and stored procedures. Currently we only have 1 subscription and 1 user...

David C

09-25-2009 03:27 PM
Paul Ibison

I have created a database in a SQL server 2005 Workgroup edition and setup merge replication to several remote PC's. The server is the publisher and...

Adam Simpson

09-25-2009 03:21 PM
Paul Ibison

A decision was made recently to take the articles from one of our publications and break them up into two publications so that we can add a new...

Ben Thul

09-25-2009 03:06 PM
Paul Ibison

Proposed designed architecture We are developing a website with following details: The basic functionality of the site is 1. The website has two...

Shamshad Ali

09-25-2009 05:55 AM
Shamshad Ali

I have started doing some research on this and this is what I came up with. We are currently on SQL Server 2008 and have a merge replication,...

Toni

09-24-2009 12:38 PM
Paul Ibison

I have 3 PULL subscriber servers with transactional replication , now for Tier 1 we want to give query to check which subscriber has failure among...

sacgar

09-23-2009 12:05 PM
ZGRAF

I am trying to set up transactional replication from a cluster to have a real time reporting server. I call it a cluster, but for true redundancy we...

scdd25

09-19-2009 04:10 AM
Paul Ibison

Hi. I have a database with tables that has identity fields and is not available for replication status. When it is created a replication SQL creates...

José Luis

09-18-2009 09:30 PM
Shamshad Ali

Hi We need Professional person who can solve our Problem regarding memory consumption due to sql server ,On finishing a work handsome amount of...

value World

09-18-2009 05:12 AM
value World

Hi. Trying to start the snapshot I got the following error: "The subscription could not be initialized using an initial snapshot because one or more...

José Luis

09-16-2009 06:09 PM
José Luis

Hi There, I'm running SQL merge replication between two servers. currently my job is stuck on the following: "The process is running and is waiting...

Reuben Rinquest

09-16-2009 12:46 AM
drewmann73

I have a table where all of the rows change every 15 minutes (it's a status table). On the system we are replicating to we don't need to know about...

Mr.Magic

09-15-2009 07:58 AM
Mr.Magic

Hi there, I need some help. I'm replicating from an Oracle server to MS SQL 2005 server using push transaction replication. If i add a new record in...

Azryll Nordin

09-15-2009 04:19 AM
Azryll Nordin

Hi there, I need some help. I'm replicating from an Oracle server to MS SQL 2005 server using push transaction replication. If i add a new record in...

Azryll Nordin

09-15-2009 04:09 AM
Azryll Nordin

Hello, i´m looking for a "deep space" documentation about the servers SQL replication. I would like to study the internal expiries under the...

Nighthawk

09-10-2009 10:07 AM
Hilary Cotter

With the merge replication setup, sometimes the subscriber DB data has invalid characters, where as the publisher data is fine. What can be the...

IEL

09-10-2009 07:58 AM
Hilary Cotter

What are the drawbacks/ potential problems with replicating over WAN? How well does SQL handle connection problems? Is it possible to use messaging...

Mikhail

09-10-2009 07:57 AM
Hilary Cotter

Hi, I have a replication from oracle DB to sql server and some of the column changed from char to nchar in replication data mapping. We have to...

stephanie

09-10-2009 02:08 AM
stephanie

I know this has been covered in previous posts but my issue seems to be unique. I am getting the error "The Merge Agent could not connect to the...

John

09-09-2009 09:16 PM
John

I've got a situation where we've got multiple production sites, each running their own instance of our ERP software, each with its own identical DB....

utexaspunk

09-09-2009 02:17 PM
Paul Ibison

I would like to know how big database is supported by SQL Server 2005 replication. Is there any restriction/limitation in table rows...

Shamshad Ali

09-09-2009 09:24 AM
Don

Hello, What are the options to replicate to no SQL DB from MS SQL 2008? //Misha

Mikhail

09-09-2009 03:02 AM
Paul Ibison

I´m trying to Add NULL or Empty String Columns to Published Columns, but I haven't found the way to edit the SQL statement, any way????? please... :S

Investigacion Desarrollo

09-09-2009 02:47 AM
Paul Ibison