You can not delete the transaction log files. These files are required for the databases to function. There must be at least one per database.
If you don't require the ability to do point in time restores then you can change the database recovery model from FULL to SIMPLE so that log entries are not kept in the log file for longer than a minute or two. This will keep the log from growing to large.
If you do require the ability to do point in time restores then you need to start doing transaction log backups which will remove the entries from the log.
In either case be sure to do a full backup on a regular basis.
Last Wiki Answer Submitted: May 16, 2009 3:59 am by Karl Gechlik9,815 pts.
All Answer Wiki Contributors: Karl Gechlik9,815 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.