Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Clearing LOD file (126 GB) RE: Clearing LOD file (126 GB)
Hadrian
Hall of Fame
Points: 3742
More actions
August 21, 2008 at 2:47 am
#861084
hello
first dbcc loginfo and check status column may be 0 or 2 ,if 0 you can
backup log dn_name with truncate _only
go
dbcc shrinkfile(log_file_id or file_name,size you want to shrink)