Hi to all
I have a merge replication over a database on sql 2005
How can i keep the log file of the database small in size without
messeing my replication?

Thanks is Advance
Savvas Christodoulou

Use the full recovery model and dump your transaction log frequently. Merge
replication is not dependent on the log that transactional replication is.

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

Well I use the full recovery model and I just dump my transaction log
with the command

DUMP TRANSACTION MyDatabase WITH NO_LOG

but the Log file size is still the same.

Any further Help?

Thanks

Savvas Christodoulou

OK, now you should be able to shrink it, Right click on the database,
select all tasks, shrink db, files, and select the log file and 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]

Thanks a million Hilary its working just fine now !

Best Rgrds

Savvas Christodoulou