SQL Server Performance Forum – Threads Archive
Log size reductionHi,
I have gone through the forum and read a few posts on this issue. I am still having the problem: My DB is about 600 MB and Log is about 2GB. I am running the following to reduce the log size to 400MB: DBCC SHRINKFILE(‘logical log name’, 400) When I run this, it does not reduce the log size. I have run this several times (as suggested in another related post), but the log size is still the same. Should I be using any options such as "TRUNCATE ONLY" and if I do, will I loose anything? Appreciate any feedback. TIA.
Take a look at: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6593
Thanks a lot. That was exactly what I needed !!!