Distribution Server and snapshot

I have a 120GB database I would like to replicate. I would be doing
transactional replication. I would like to know what amount of disk space I
will need for the snapshot and the distribution database.
What effect on performance does having the distribution database on a
production server? Can distribution database be on the other side of a WAN
from the publication database?
What is performance hit difference between syncronous mirroring verus
transactional replication on the primary database server. I have SE 2005
x64 SQL server so I can only do syncronous mirroring.
Thanks,
You will probably need about 120 Gigs for the snapshot. The size of the
distribution database is a function of the amount of data you push through
it on a daily basis, if your subscribers are named or anonymous (anonymous
means much greater storage), and what your latency is.
Mirroring in general consumes less resources than replication.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Cindy" <Cindy@.discussions.microsoft.com> wrote in message
news:FCFE4B7B-69DC-4CAC-A5CD-7E1360374782@.microsoft.com...
>I have a 120GB database I would like to replicate. I would be doing
> transactional replication. I would like to know what amount of disk
> space I
> will need for the snapshot and the distribution database.
> What effect on performance does having the distribution database on a
> production server? Can distribution database be on the other side of a WAN
> from the publication database?
> What is performance hit difference between syncronous mirroring verus
> transactional replication on the primary database server. I have SE 2005
> x64 SQL server so I can only do syncronous mirroring.
> Thanks,