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 |
|
imarchenko
Yak Posting Veteran
57 Posts |
 Posted - 2009-01-26 : 11:28:27
|
| Hello! I have setup transactional replication (4 publications) between two SQL 2005 servers. Distributor is on the same server as Publisher. Distribution jobs are running once a day. I have noticed that space consumed in distribution database keeps growing. Even after I manually execute distrubitoon jobs space is not reclaimed. When I check 'Undistrubuted commands' in Replication monitor right after synchronization with Subscriber it shows me 0. I was wondering when and how space is being reclaimed in distribution database. My understanding is that once transactions are delivered to Subscriber, they should be removed from distribution database. Any help is greatly appreciated. Thanks,Igor |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-27 : 07:29:07
|
| Are there any objects created on it? What is the retention period for it? |
 |
|
|
|
|
|
Space is not reclaimed in distribution database