Shrinking (enormous) log files

Hi there

I've got a site currently that has a data file size of 48Mb, and a log file of 48Gb.

I tried running dbcc shrinkdatabase which ran correctly but it didn't change the log file size whatsoever.

I also tried right click on database name and ran Shrink that way, again no discernable effect (other than it increased briefly to 50Gb then dropped back to 48Gb).

Is there any way to reliably shrink this log file please? 48Gb is getting unmanageable.

Thanks,
Simon

hi,
you can delete it.

Bit of research and I found a method:

1) Take a full database backup

2) Set the database recovery model to SIMPLE

3) Resize your log file - I set it to 50Mb in this case

4) Go back into properties and set your recovery model back to Full

This seemed to do the trick, without problems associated with deleting the log file.