In SQL 2005 Microsoft recommends not to mirror more than 10 databases between
2 servers.  Is there a way around this or is that a hard and fast rule?  Can
anyone point me to documentation on how to if it is possible?

Here's the sample script
==================
-- DB system: MS SQL Server 2005 Standard
-- Objective: create a snapshot for merge replication

OS: Win Server 2003
SQL: 2005 SP2 + CU10
We use Transactional Replication for our prodoction DB to replicate it to
another node in Cluster to be used as a reporting server.

i am using merge push subscription.
i have to update/modify  the schema  in publication db.
So the changes in the publication db should be reflected in Subscriotion db.
i have more than 25 subscribers. How can i do the schema changes ?.

Hi Freinds,
SQL2008
I am trying to create a new publication but as I go to new publication
wizard page where I should select the database, the screen freeze and

We'll be implementing replication soon but we have some concerns in the case
of disaster recovery.
My question revolves around the transaction log on the publisher.
Setup

I would like to initiate transactional replication without using an initial
snapshot or backup restore.  I just want to replicate the latest delta but I
don't need the current data.  Is this possible?

I want to find programaticaly some table in an existing snapshot file.
How can I do this? Please don't  tell me about sysmergearticles table.
Any idesa?
Zaza T

SQL Server 2005 sp2 CU9 (9.0.3282)
I am trying to use this sp to alter an article's propert but get this error,
any idea?
EXEC sp_changearticle

How to make existing snapshot invalidate without
reinitialize the active subscriptions?
When I tried to do with this code:
EXEC sp_changemergearticle

I have a problem with replication service on sql server 2005. I have 2
servers. Master server is in a site (Rome for example) and target site is on
Paris (for example). On the Paris server I have setted a pull subscriptions.  
Local publications is on the Rome server. I have ...

I have a SQL Server 2005 Sp2 server (ServerA) located in one data center
(DC1). As part of a tax SOP & disaster recovery strategy we have decided to
have one more box (ServerB) in a data center (DC2) in tax free country and
mirror the data between ServerB & ServerA. ServerB would ...

  I have setup transactional replication (4 publications) between two SQL
2005 servers. Distributor is on the same server as Publisher. Distribution
jobs are running once a day. I have noticed that space consumed in
distribution database keeps growing. Even after I manually ...

Ok, the snapshot was initially set up to run continuously.  Now, I'd
like to change it ONE time only, that is, a) the snapshot will be
pulled by any future new subscriber ONCE upon subscription; b) it will
stop other existing subscribers from pulling the snapshot from this

Day One
-------------
Publisher -- I have a snapshot replication, naturally it created a
snapshot agent job.