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