I had a situation where rebuilding the indexes ran for 1 day and filled the disk with 1.5TB.
also splitting tables of a very large db to do every nighht if we have a windows
and the log backups were taking ever and not truncating the log..what helped me to rebuild indexes and not to fill disk is below
- changed db to bulk recovery model from full
- rebuild indexes
- changed db to FULL recovery model
No comments:
Post a Comment