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 |
|
gogia.jaswinder
Starting Member
4 Posts |
 Posted - 2009-08-07 : 19:27:57
|
| Hi I am new on replication, I am setting up new merge replication on Sql server 2005 with 13 Gb of DB.I found replication server has 6 GB of distribution of DB MDF file size and 6 GB of LDF.I ran DBCCShrink and worked and shrinked the LDF file to 2MB. but MDF is same.How to run a periodic job so that MDF will also shrink or clean which has distributed on subscribers.Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-08-07 : 22:45:07
|
| Make Sure Distribution Cleanup job is happening in interval you have chosen. |
 |
|
|
gogia.jaswinder
Starting Member
4 Posts |
Posted - 2009-08-08 : 01:03:11
|
quote:
Originally posted by sodeep
Make Sure Distribution Cleanup job is happening in interval you have chosen.
Could you please let me know how to setup Distributor clean up job.Is it under Maintenance Plan ... Could you please explain as I have to setup urgently.Regards |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-08-08 : 14:36:39
|
| The job is there while creating replication. Your job should succeed in defined interval. |
|
|
|
|
|
|
How to setup a Distribution clean up job