Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chris_cs
Posting Yak Master
223 Posts |
 Posted - 2011-06-06 : 06:44:23
|
| Hi Guys,I have a job that rebuilds the indexes on one of our databases every Friday night and it seems to bloat the log quite a bit.I just wondered if I should switch the recovery model to bulk logged before the indexes are rebuilt?Is this the correct way to go? |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2011-06-06 : 09:54:33
|
| That will not make any difference.You should try running the transaction log backups more often, like every 15 minutes, 24x7.CODO ERGO SUM |
 |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-06-06 : 10:26:32
|
| What would happen if the log backup ran at the same time the index rebuild was happening?I've always been nervous about those types of things so I try to avoid them clashing. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2011-06-06 : 10:38:41
|
| It won't hurt anything.You may still see substantial log file growth, because you are changing so much data in a very short period of time.Don't bother trying to shrink the log file. Just let it grow to the size it needs to be and let it stay there.CODO ERGO SUM |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2011-06-06 : 10:52:37
|
| Ok thanks for the tip.The data file is just over 20Gb and the log file is now over 3Gb. I'll look at changing the backup strategy so that log backups are taken more frequently as well. |
|
|
|
|
|
|
Index rebuild job