January 3, 2010 at 5:29 pm
Folks
My replication has grown over the last 3 years and now the table holding my (clients)images has exceeded 2 gb
When I do a Snapshot replication I get a error
When I reduce the table or filter the data to a smaller set it works
Is there an upper limit on Snapshot replication
Also where does the files for a snapshot reside on the subscribers computer
regards
GregJF
January 3, 2010 at 8:57 pm
I am not aware of any size limits on Snapshot Replication.
What is the error that you are seeing?
The snapshot files are applied at the Subscriber by Distributor right from the distributor, snapshot files are not moved physically to the subscriber and they are not locally applied. I may be wrong in this.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 3, 2010 at 9:29 pm
I don't think that last statement is correct else how would a Merge replication get started if that merge replication was not connected to the distibutor eg done by CDROM/DVD?
January 3, 2010 at 9:38 pm
GregFrazer (1/3/2010)
I don't think that last statement is correct else how would a Merge replication get started if that merge replication was not connected to the distibutor eg done by CDROM/DVD?
I think you have not mentioned anything about Merge Replication any where in your Original Post and the point I was referring was also not related to Merge Replication?
I have not mentioned any where about connectivity either.
I think you have not got what I meant, can you rephrase what do you mean?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 3, 2010 at 9:47 pm
Well, Snapshots are used to initialise or reinitialise Merge and Transactional replications
The snapshot that I am using for reinitialisation of a merge replication, every 14 days, has grown so now it is above 2 GB in size and failing with an error:
"Server returned invalid response"
Not a very helpful message!
The snapshot and merge replication is happening via IIS
Up to this point it had been working for 3 years.
If I reduce the articles or filter the largest table so that the Snapshot size is below 2 gb it works!
Hence my question regarding the size of the Snapshot
regards
GregJF
January 4, 2010 at 6:23 am
there is a 2 gig limit on the size of compressed snapshots. Microsoft has not fixed this problem yet or created a workaround.
January 4, 2010 at 3:46 pm
SSC Veteran
I actually new that so I am not compressing the snapshot.
Any other clues or limits that I should be aware of
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply