Shrink SQL Server Log File

re: Shrink SQL Server Log File

Scriptor — Sat, 19 Aug 2006 12:16:19 GMT

Sounds handy, while my database logs aren't that big, I'll keep this in mind since I have to use free hosting, which is way less space.

re: Shrink SQL Server Log File

Gary Evesson — Mon, 21 Aug 2006 06:50:54 GMT

Try

backup log '<database name>' with truncate_only

instead of changing the recovery model. This marks all the inactive transactions in the log file as ready for removal.

re: Shrink SQL Server Log File

chris hulbert — Sun, 27 Aug 2006 19:06:00 GMT

You needn't do the 'SET RECOVERY FULL;' at the end: you may as well leave it in 'simple' mode. After all, its only a blog.
That way, the log won't balloon again.

re: Shrink SQL Server Log File

MP — Thu, 01 Mar 2007 05:07:13 GMT

Thanks! Really helped me out!

re: Shrink SQL Server Log File

Jothi — Sun, 06 May 2007 22:36:02 GMT

Very Thanks! Its the solution i want.