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 |
|
thombeaux
Starting Member
18 Posts |
 Posted - 2007-08-02 : 15:37:41
|
| What job cleans out the distribution database?Cna you perform maintenance to keep the size down?Thanks,ThomasThomBeaux |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-02 : 23:19:45
|
| Should have distribution db clean up job, ensure it runs in schedule without error. |
 |
|
|
thombeaux
Starting Member
18 Posts |
Posted - 2007-08-03 : 10:40:15
|
| What is the name of the job?ThomasThomBeaux |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-03 : 11:19:02
|
| Something like 'Distribution clean up: distribution' on distributor. |
|
|
|
thombeaux
Starting Member
18 Posts |
Posted - 2007-08-03 : 14:23:55
|
| This is the history:Removed 0 replicated transactions consisting of 0 statements in 50 seconds (0 rows/sec). [SQLSTATE 01000] (Message 21010). The step succeeded.Never does it say "Removed >0"ThomasThomBeaux |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-03 : 23:25:22
|
| Did you check distribution db's recovery model? How big is its log file? Is distribution agent running? |
|
|
|
|
|
|
Distribution Database 9GBs