SQL Server Transaction Log Size...

[jaymdouglas]

Hi,

I am currentley using a SQL Server 2K db on a host (www.webhost4life) and when using MS Enterprise Manager I noticed that my data file size is 2.5 megs, and the transaction log is approaching 100 megs.

Is there someway I can back up the existing data, back it up and then delete that log file and start again. Or a simpler way to keep that transaction log file size down?

Thanks..

[dj4uk]

http://msdn.microsoft.com/library/de...r_da2_1uzr.asp - see the related links at the bottom of the page also.

[wes271]

I use

DUMP TRANSACTION [imoReconcile] WITH NO_LOG

in the query analyzer to clear out my transaction log. but first you must back up the data file as well as the transaction log. after you run this query

DUMP TRANSACTION [imoReconcile] WITH NO_LOG

you transaction log should be virtually empty