Database Log File TOO LARGE

[johng75]

over time our database log file has grown to 12GB, aparently we never set any caps or purging options, and now the partition made for the log files is full, what is the most effective way to clean up this file?

 

[AllUserNamesAreTaken]

Delete it

 

[johng75]

how will that effect the verits software? will it be able to just carry on without the old log file? and just create a new one? or?

 

[AllUserNamesAreTaken]

I assume a log is just a log. Deleting a log won't have any effect - apart from the exception of Exchange.

I may well be wrong, but if it's causing serious partiton space issues, deleting a log won't cause your system to hang/crash, although keeping a drive full may.

http://seer.entsupport.symantec.com/docs/257140.htm

 

[johng75]

the log file is the BEDB_log.ldf file that is in the SQL database for the veritas software........

 

[AllUserNamesAreTaken]

http://forums.veritas.com/discussions/thread.jspa?threadID=46824&messageID=4364651

 

[steveot]

Have you tried using OSQL to purge the log files? Seems there is something wrong with the MSDE install.

 

[macleod1021]

You don't want to just delete the log file. If you do, SQL will mark it Suspect and cause it to become unuseable.

If you go into Enterprise Manager, you can create a maintenance plan that will do a backup of the transaction log. One of the options is to truncate and shrink the log file. That will take care of it for you.