sql-server-maintenance-solution icon indicating copy to clipboard operation
sql-server-maintenance-solution copied to clipboard

Resumable index rebuild

Open NanxMin opened this issue 4 years ago • 0 comments

Hello,

I have a question regarding the maintenance script responsible for index rebuild / reorganize. Since our database is quite massive, we've been thinking about implementing additional parameter: RESUMABLE = 'Y'. We are executing the script once a week during the maintenance window and we also have additional script to kill it after several hours. I understand that once we implement index rebuild with resumable option, we will be able to continue the rebuild right where it has stopped. However, I wonder if the maintenance script will start next week from that specific index that got interrupted or will it start again from the very beginning and then it will reach interrupted index?

NanxMin avatar Oct 07 '21 13:10 NanxMin