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 |
|
pushed into it
Starting Member
2 Posts |
 Posted - 2012-01-18 : 10:15:47
|
| Hi We have a plan that runs on a sunday that re-org's the indexes on one of our larger DB'S (about 50GB) This then creates a log file that is around 100GB in size, we do hourly translog backups and this then clears down the data, but still leaves the size of the log file the same, just 99% unused space. is there a way of performing this task with having the massive log file being created.The only way I have seen to reclaim the space is to shrink the log file, but from what I can see this is not good for frag lvl's etc and is couter productive. any ideas as disk space could be a problem Thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-18 : 10:26:35
|
| Reorganise or rebuild?--Gail ShawSQL Server MVP |
 |
|
|
pushed into it
Starting Member
2 Posts |
Posted - 2012-01-18 : 10:46:16
|
| Reorganise |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-18 : 11:12:32
|
| You can increase the frequency of the log backups over that time, it'll keep the log smaller and keep your log backups smaller.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
re-org index and massive Log file