Feature request - Omit indexes on restore

EdVassie

Description:
The restore process should have an option to omit all non-clustered indexes during a restore. The index definitions should be restored, but the index data omitted.
Pages that contained the non-clustered indexes should be restored as empty pages.

Justification:
This should speed up the restore process for situations where only the data is needed (e.g.when restoring Prod databases to non-Prod systems, or when distributing copies of databases to developers)

Colin Millerchip

Thanks for this suggestion. We always like to hear suggestions on how we can improve our products, and whilst we can't promise to implement them in the next release, we can promise to take them into consideration.

Best regards,


Colin.