We are trying put together a disaster recovery plan for our production SQL
databases including our ERP database and some other dbs.
We have 3 SQL Servers all running SQL 2005 Standard.  2 servers are
production servers and a third server can be utilized for a backup/mirror

Actually subject says every thing. Our database was 20GB in size and after
setting up replication its size is 73GB (with log).
Transaction Log's size is 10GB and 99% of it is empty and this is not a
concern because I can handle this by shrinking it.

merry christmas and happy new year.
beacuse of virus my sql 2005/2008 replication is broken. i have a backup for
publication, distribution,subscribution. how can i restore my replication on
new sql server and if the subscribtion contains a new transactions that not

I've got merge replication between two servers (bi-diretional) data
merge working.  Now, when I attempted to do a bit more, got into a
problem.  Here's the scoop.
Publisher and Distributor = Central Server which has the main database

I'm running SQL 2005 (9.00.3050.00)  MSmerge_history tables are not
getting cleaned up and when the "Agent history clean up: distribution"
job now tries to run every 10 minutes it hangs and fills up the
transaction log till I'm close to running out of disk space. I need to

Hi, we'd like to know what the sql server replication uses at network level
to transfer data. Does it use ODBC?  Is there any article addressing this?
Thanks in advance.
Pingx

Scenario: SQL 2000 1 publisher (Merge and Trans), two subscribers.
Problem: Subscription expiration for Merge Publication set to 'never expire'
hence MSMerge_contents = 44million rows. MSmerge_genhistory = 9 million rows
When pushing out to new subscriber this is causing a)snapshot ...

We have got a weird problem which we can't manage to understand. I'll be
grateful if anyone can help.
Here's the scenario:
We have got a 2 node Cluster SQL Server 2005 Enterprise Edition (SP2) on

Hi, I have a rather large 500GB sql 2005 database I'm trying to mirror, I
have everything inplace ready to go but I keep getting the below error, I
have closed all connections, I have ran the commands to kill all connections
and to set it to single user mode but I still get the ...

I'm using tablediff to compare tables from two different databases and
generate an update script. I'm facing a problem with tables that contain a
decimal column.
The decimal separator is a ',' on my databases, since I'm in france, so the

I am using Merge Replcation. Everything works fine except One Table
Data in Only One Column of Some  Rows in that table is different at
subscriber and publisher.
I am using Pull Model. and Row Level Tracking for the table.

I've setting up a mirror, the database is 500GB, the .trn files are 400MB
every 15 mins, issue is when I restore the DB I can never catch-up the replay
of the .trn files to start the mirror because the replay/restore of the .trn
files takes hours, is there a solution for this? or ...

i have a 32 bit custome resolver, it is a .net assembly. will i have any
issues to install and use it in 64 bit environment (os ans sql server)

I have a publisher db with a table having a trigger that updates a
column in a newly added row. So, for example, there is a table A with
column B. When a new row is added to A, trigger updates column B.
The replicate (subscriber) db's table A doesnt have above mentioned

We have a fairly standard merge replication setup on SQL 2005 with MSDE
subscribers.  (We previously used SQL 2000 with MSDE subscribers)
All of our published articles have the same properties:
@pub_identity_range = 250,000