sql server replication: Hi guys - I noticed that some subscriber's databases have an incredibly
small mdf file and a large ldf. As an example one mdf is 1.4 MB and the ldf
is 250 MB. The 250 MB should really be the size of the mdf. What is going
on?

Thank you,
Maer

Is it possible that the snapshot is still being applied? Can you back up the
log and then try to shrink it?

--
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]

Please check out Raymond Mak's recent posts in a few threads on this topic
which are most likely the cause of the balooning of your transaction logs.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .