Service Desk Practitioners Forum
cancel

Large LDF file

SOLVED
Go to solution
Highlighted
eric verdin_1
Contributor.

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
Acclaimed Contributor.
Solution

Re: Large LDF file

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

Vasily