Setting the size is not important in SQL 2005. If you are concerned about
the size of the physical database, dump the tlogs frequently.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

Hi

My disribution DB is automatically set and the databse size is about 800 MB.
now i am planning to set distribution database to fixed size as microsoft
recommends Can anyone tell how much can i set upto.... and that should not
degrade performance wise.

Your help will be appreciated

Thanks,
Pardhi

--

Thanks Hilary

[quoted text, click to view]

--
Message posted via SQLMonster.com