February 7, 2012 at 8:32 pm
Hi,
I've got a subscription worth around 100GB. It takes around 13 minutes to generate the snapshot and more then 4 hours to apply it on the subscriber. I am truncating the table on the other end if it exists (I can't drop it).
Is there a way or a replication setting I can use to speed up applying the snapshot on the subscriber?
Any ideas are appreciated.
Thanks.
February 7, 2012 at 10:26 pm
Hi,
How many tables you are truncating, like if you ave five table very large then export the data than delete from table subscribe it then import in publisher.....
I accept it is not a correct way but you can save the time...
Thanks & Regards
Satish
February 7, 2012 at 11:15 pm
saidapurs (2/7/2012)
Hi,How many tables you are truncating, like if you ave five table very large then export the data than delete from table subscribe it then import in publisher.....
I accept it is not a correct way but you can save the time...
Thanks & Regards
Satish
May be 60-70. I can't do any manual steps there, besides importing and exporting the data on the publisher is not an option. What I am after is about some sort of setting I could use to make the normal re-snapshoting process quicker. I can't drop the indexes on the subscriber prior to re-snapshoting either.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply