Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Clearing LOD file (126 GB) RE: Clearing LOD file (126 GB)
manoj2001
SSCrazy
Points: 2225
More actions
August 22, 2008 at 3:01 am
#861711
your log size is in GB while Data file size is in MB, it seems you are not taking backup of log.
if log backup is not necessry for you then use command TRUNATE_ONLY and truncate the log.
hope this will work.
Manoj