The "distribution" database on 2005

[Eddiefdz]

Hello,

There is a database called "distribution" which if i am not mistaken is used to keep replicated data, etc. Can i purge that database or shrink it perhaps? It takes up over 45gigs of space and it keeps growing. How long does the data need to stay in there?

Thanks,
Eddie

Eddie Fernandez
CCNA, Network+, A+, MCP

 

[AlexCuse]

note - I don't know anything about replication except what it is...

Still, what kind of maintenance plan do you have currently? It sounds like you have a transaction log that is growing out of control.

Good Luck,

Alex

[small]----signature below----[/small]
I don't do any programming whatsoever

Ignorance of certain subjects is a great part of wisdom

 

[ptheriault]

Do not touch the distribution database. It contains all the metadata and replication commands. You will mess up replication if you mess with those tables. Check the msrepl_commands table. It will be the largest. That table contains all the commands that need to be applied to your subscriber.

What kind of replication do you have set up?

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

If that database is growing then replication isn't replicating the transactions to the subscriber. Check the replication monitor and see which subscriber(s) have fallen behind.

The distribution database should be fairly small under normal conditions. The only time it should really grow is when replication is behind schedule.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com