October 31, 2014 at 4:55 pm
Hi Experts ,
My logs drive is getting full while re-index job is running, its rebuilding indexes online and we have a Transaction replication running continuously. We are rebuilding indexes on Publisher , Distributor and Subscriber using Idera Defrag manger. I have seen in that replication log reading is continuously reading logs and it goes into millions. Can any one guide how can I re-build indexes online and log disk won't get full.
Please help
Thanks
November 5, 2014 at 1:02 pm
There is no way you can stop SQL Server from writing to the log when rebuilding indexes. Saying that you have 2 options:
1. Rebuild less. For example, increase threshold after which you rebuild indexes. Or don't rebuild all indexes at once.
2. Get more disk space.
November 6, 2014 at 5:35 am
i had the similar issue and now i am using following technique to rebuild indexes which are only required to be rebuild.
1. Check the fragmentation greater than 30% and pages greater than 1000 then rebuild
2. Check the fragmentation between 15% to 29% and pages greater than 1000 then reorganize
3. Update the statistics the first two conditions is false
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply