Log File Problem

[riya]

Hi all,

How to Delete the Log files Accumulated in the server thro' Query Analyzer(I mean TSQL Command)?

Thanx..

 

[foxdev]

You can't normally delete the log file; you can shrink it through various means, but you should not delete it. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org

 

[Cagliostro]

You may also detach database, delete log file ant attach it again. John Fill

 

[tmp14]

Which log files are you referrinf to - errorlog, transaction log or backup log? if the database log is too large or not getting deleted properly, after performing a full database backup you can run dump trans XXXXX with truncate.