Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blorg
Starting Member
4 Posts |
 Posted - 2008-04-30 : 08:33:55
|
| Quick question- how much disk space is required on the subscriber to initialize a subscription (transactional replication) – does it have to copy the snapshot files (e.g. the bcp files etc) from the distributor, and then initialize the subscriber from this, or does it do this over the network?Does it differ depending on whether it is push or pull?Say I have a 10 GB snapshot on the distributor with a push subscription to the subscriber. Do I need 20 GB free on the subscriber? E.g. 10 GB to receive the snapshot files + 10 GB for the subscriber DB? Or just 10 GB for the subscriber DB which is initialized from the snapshot files over the network?Thanks in advance for any help with this. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-30 : 11:36:03
|
| 1)depends on how much data you are replicating2)Not really, you use pull subscription so distribution agent runs on Subscriber instead of distributor3)Nope. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-30 : 21:56:06
|
| For 10gb db, subscriber needs more disk space than that since db will grow. |
|
|
|
|
|
|
Disk space required to initialize subscriber