I wonder if anyone out there know about a book on replication you can
recomend? A book that is easy to read but with advanced things as well.
thanks
//Regina

I have a question about merge replication. We hav one server as master and 3
subscribers. In prodoktion we have noticed that the replikation takes time
that we wish to reduce. one way to try to reduce the time is to drop two
articles from the merge replication.  When I was trying ...

During a deploy I managed to break a subscription.  Obviously the
answer is to refresh the subscription with a snapshot.  The problem
I'm running into is that these subscriptions are all on a shared
agent.  So I'm getting this error message:

I have had an instance where certain rows have disappeared from the main
server following a replication session.
We are using Merge (pull) subscriptions using SQL2K standard as publisher
and MSDE as the subscriber.

I am having problems setting up database mirroring (SQL Server 2005).
I made a backup of my database and transaction log, I restore this on
my Mirror server.  I established the end points and I set the partner
on my mirror server, I then received the error  "The remote copy of

question: I need to setup a Data Warehousing/Archiving Database.  Data needs
to move from our production database over to this new database.  There are a
few large tables that we would want to purge old data on our production
Database, this would be done on a monthly schedule.  ...

I am trying to configure merge replication on a machine that crashed. we
have reloaded everything and loaded SP4 for SQL 2000. When I try to
configure the subscriber, I receive an error
msdb.dbo.sp_add_jobstep_interval is not found. I looked in the msdb

We changed the 'sa' password on the subscriber to the exact same
password but then the transactional replication from the distributor
to subscriber is throwing this error:
Login failed for user 'sa'. (Source: MSSQLServer, Error number: 18456)

We are facing trouble while setting up transactional push replication
between SQL 2000 and SQL 2005.
Publisher--SQL 2000
Distributir and Subscriber--SQL 2005 on same machine.

Where might I begin debugging the following:
When I update a row on the Updatable Subscription, I'm getting the following
error:
<start>

I have a need to create an exact duplicate of a SQL database within the same
domain.  This duplicate copies must be 100% synchronized at all times and
they both need to be updateable.  This database is the back end for a
commercial softwarre application for which we do not ...

Our database running on SQL Server 2005 (with SP2) version and one large
database have transactional replication setup on it. The daily loaded data
around 80 million records. The log reader agent latency goes to 6 hours. I
checked web site, it says use -MaxCmdsInTran, ...

I went down the replic and then mirroring route and now since the goal posts
have changed for my project yet again, im back to the drawing board (again)
I have a requirement for users to be able to access either the production OR
the mirror / replica / hot / whatever server ...

I am trying to consolidate replication - I have several dozen
publications that each go to anywhere from 1-20 subscribers.
Performance is not where I want it, and it appears to be tied to the
push subscriptions we have on the main machine.  We have 3 options:

We are running a replication on SQL 2005 Win 2K machine. We have modified
Store Procedures used by replication to block some columns getting replicated
under certain scenrios
The problem occures when these column contain '#' char. The replication