March 23, 2011 at 7:52 am
SQL server 2008 R2.
The databse size was 30GB initially and after running the nightly indexing ( a scheduled plan - that indexes few tables ) the database file has grown to size 53 GB now. The log file size grew to 21GB from 15GB. Now how should I reduce the size and why does this happen?
Thanks in advance for the help.
March 23, 2011 at 8:27 am
Do you have a transaction log backup job? That will help to clear the Log file.
As far as the db size increasing, that is a pretty big size jump. Depending on the database, you can see an increase in size due to the fill factor that is used on the index rebuild. You may want to check on that. Additionally, you may want to run sp_spaceused on the tables to see where the size is coming from, data, index or unused space.
March 23, 2011 at 8:41 am
yes, I have the transaction log back up running in every 1 hour. does that mean the log file is growing because of this?
March 23, 2011 at 8:54 am
It depends on the recovery model of your database. My guess you are in Full Recovery, so it writes a lot to the log file.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply