February 27, 2011 at 10:36 pm
Hi Experts,
I'm setting a up transactional replication using MSSQL server 2005.
My Publisher is around 1TB.
How much space should be allocated to my Snapshot folder and distributor database ?
What will be the size of my initial snapshot?
And while creating and applying initial snapshot where will be the data stored?
Once the initial snapshot is applied to subscriber where will the newly published data be stored?
Regards,
Eswin
Tanx 😀
March 1, 2011 at 8:03 am
Are you planning to initialize the 1TB DB using Snapshot? That would just give timeouts and/or take way too much time. Since it is a 1 TB DB, the preferred method of initializing would be Back up and restore.
What is the amount of data changed? Is it very high? Depending on that you will have to size up the Distribution DB. Keep in mind that there are Jobs that clean up the replication commands. If it is working properly, your Distribution Db wont grow. The Max it would grow would be around 15 GB.
-Roy
March 2, 2011 at 1:06 am
As Roy said - the preferred method would be to initialize via a backup. We ran into the same issues (timeouts, taking a very large time etc even though we tried options like compressing the snapshots etc) when we tried to see if initialization via snapshot would work for our 1TB DB (we went with initializing via a backup for this).
This article has details around how to initialize via backup (SQL 2008 specific though).
Regarding where the data will be stored during the snapshot process and after the snapshot check out the replication stairway article here[/url]
March 2, 2011 at 4:11 am
Thanks a lot.....
Actually I wanted to know where exactly the published data will be stored 'Snapshot folder or Distributor database' and how much disk space we should need to give for 'Snapshot folder and Distributor database'.
Tanx 😀
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply