Monday, March 26, 2012

log files

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.

No comments:

Post a Comment