Resumable index create or rebuild does not require you to keep open a long running transaction, allowing log truncation during this operation and a better log space management.. GeoPITS brings you the comprehensive details of Resumable online index rebuilds's support in different versions & editions of SQL Server.
Version | Enterprise | Standard | Web | Express (Adv.) | Express |
---|---|---|---|---|---|
Version v2019 | Yes | ||||
Version v2017 | Yes | ||||
Version v2016 | |||||
Version v2014 | Yes | ||||
Version v2012 |
Resumable index create or rebuild does not require you to keep open a long running transaction, allowing log truncation during this operation and a better log space management.
You can find more details about this version here