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 |
|
ay2k_99
Starting Member
22 Posts |
 Posted - 2009-06-05 : 01:16:51
|
| Dear All,We have peer to peer transactional replication setup, every thing is ok with replication. se the job MS_distribution_cleaup job it was running fine. but when we see the datafile and log file of the distribution database it was growing. it was not delete data from replication transaction and command table. pls help for this...Thanks, |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-05 : 14:35:23
|
| the job might be running fine but the default retention period (I think of 72 hrs) can be reduced to even shorter or you can increase the frequency of the job... however I wouldnt normally muck with these default timings..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Distribution CleanUp