now when we do backup it store only index definition without data it is ok from backup time POV and backup size POV but restore time is increased by need of recreation of indexes data.
Especially it need very big disc space to sort index on big databases at recreation time.
Will be good to see option to backup database with index pages then restore time will be faster and will consume small amount of resources.
Nbackup is not good here because we need to have table data reorganized and defragmented. We can accept index fragmentation.
Will be good also to have switch to ignore index data form backup file if backup was created in this new way.
This is slightly corealated with CORE-2992