We would like to test a transactional replication (push) using a
snapshot recently copied on a DVD. Did anyone try this ?
Thank's in advance for your answers,
Regards,

sql2k sp3
I am using Log Shipping with Transactional Replication.
The Publisher transfers tlog backups to a Backup
Publisher. The goal is to be able to switch over to the

We are looking into web synchronization between SQL2005 standard &
offline clients using Express2005. We would like to implement this
into our current environment but my findings lead me to think this
cant be done as follows:

Our company is having issues with reporting on real time data. We are using
SQL Server Reporting Services and SQL Server 2005, our reports are generated
from a Datawarehouse that is poplated using replication. Difficulties we are
running into is, reports that are running on the ...

Greetings,
I have recently started working in an environment that uses replication
extensively. As part of that there are times where we are seeing some high
latency times. I am wondering if there are some key queries that I can use to

I have 212 publications for push transactional replications on SQL Server
2005 Ent SP2 + WinSrv2003. 190 of them between 2 servers.
And I have issue with Distribution Agents.
LogReader agents are working properly. All publications synchronized.

I'm trying to modify a table in SQL Server 2005 but I get the following
error:
Cannot drop the table 'dbo.aArtiEmp' because it is being used for
replication

Hi Experts,
We have several prodution servers which replicates the DB to centralize
location(PUSH transactional replication), For development testing we require
the DB to take backup and then copy the backup and restore on the Dev server

I am having an issue using transactional replication on a SQL 2005 SP2
system when trying to replicate an Image data type.  The data won't
write to the Prod system, let alone replicate.  However, when I remove
the table from the publication everything works fine.  I show no error

I have set up transactional replication for ten tables. However, after a
month the log size on the publisher has started growing and it has become 50
GB in size. What should be done to decrease the log size and to keep it
small. Thanks in advance.

SQL2000 Enterprise Edition SP3a
I have transaction replication set up between two servers, nothing out of the
ordinary. I need one of the tables being published to be filtered two
different ways to the same subscriber.

We have a problem with sp_repladdcolumn. We have publication names
that have a comma in them. This causes sp_repladdcolumn not to work
right. Is there a way to rename a publication without having to drop,
recreate, or reinitialize?

I am trying to merge publish a sql server 2005 database using sql server
200o options. The publishing wizard wants to add a uniqueidentifier column
to a table even though the table has an auto-increment PK. Why is that? How
can I add a uniqueidentifier column myself?

I have a merge replication setup between SQL 2005 and SQL express.  I am
running this for a few different locations and I have not had many issues
with any of them.  The other day one of my publications started to hang.  I
cancelled the job and set verboselevel 2 and had it write ...

Hi guys my DTS loading at night takes 8h and now I need to triple the data
to 300GB. Am I naive hoping to load 3 instances with replication at almost
the same time - aka can afford only about 1h delay
Thanks!