July 20, 2011 at 9:23 am
My database file size is 53 GB and the log file is only 21 GB. I have done several index rebuilds. I understand that,the rebuilding of indexes will grow the databasefile size. But the size is more than double of the log file.Is this normal? Should I shrink the database though I am not sure what effect it will have on the database. Any pointers will be greatly appreciated. Thanks!
July 20, 2011 at 9:30 am
Wow, normally people are complaining that the log file is too big...
Leave the files alone unless you have a really good reason to do otherwise.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 20, 2011 at 9:44 am
GilaMonster (7/20/2011)
Wow, normally people are complaining that the log file is too big...Leave the files alone unless you have a really good reason to do otherwise.
Ya that's a nice change of pace.
Also you might want to stop reindexing everything at every run. This allows you to work only on what is required :
http://sqlfool.com/2010/04/index-defrag-script-v4-0
Once you got it running perfectly for your system, you'll be able to reduce your log files even further and save up on that precious san of yours.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply