Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Large LDF file

SOLVED
Go to solution
Highlighted
eric verdin_1
Occasional Advisor

Large LDF file


SQL 8 running Service desk 4.5
I have a very large LDF file that I would like to delete or shrink, what is the best way to do this?

Thanks.

1 REPLY
Vasily Kamenev
Honored Contributor
Solution

Re: Large LDF file

Hi
Backup log file, then try this:
Use
go
backup LOG with Truncate_only
go
DBCC shrinkfile()

Vasily
//Add this to "OnDomLoad" event