hi
when size of my lof file become full than it shows the error....so for this i manully delete the content of my log file...than it does not show the error....can anybody tell me any better way to avoid manual deletion...
thanx a lot
Right click the database go to Tasks->Shrink -> Files, select the log option and give a very small size.
after that run this command,
BACKUP LOG <db name> with TRUNCATE_ONLY
your transactional log size will be reduced in this manner.
|||hi thanx for reply....u mean i have to do what u said each time ...here also we are doing manual deletion....any automatic way to do this ?|||You can by developing a SSIS package with a Shrink Database task, call it using a SQL Server agent job and then schedule it as your need be.|||after right click it is showing shrink option disabled.why?|||The options I had said is for SSMS 2005. What are you using ?|||sqlserver 2000|||
Check if this helps....
http://support.microsoft.com/default.aspx/kb/272318
|||Frequently backup you database and log.This is the way you can keep the log from growing.
