What are the challenges you face when working across database platforms? Take the survey
Options

Feature request - Omit indexes on restore

EdVassieEdVassie Posts: 15
edited April 10, 2008 12:07PM in SQL Backup Previous Versions
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)

Comments

  • Options
    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.
Sign In or Register to comment.