question

chinna avatar image
chinna asked

Replication Limitation

Hi, how many number of subscription db's can we add within a server in SQL2008R2 Developer edition? How many transactional replication setups can we configure with in a server?
replication
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered
http://msdn.microsoft.com/en-us/library/ms143432(v=sql.105).aspx#Replication is a starting point for discussing replication limitations.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

chinna avatar image chinna commented ·
Thank you Thomas ,what is the limitation for publications?
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
The first couple of lines in the Replication Objects table gives you the maxima for numbers of articles in different publication limits.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.