In any RDBMS (SQL Server, Oracle, MySQL, etc.) when you do a restore, you have to have all of the files, and all of the pages agree what version you restore back to. Consider this:
- You "back up" the index
- Users add entries to the table
- You "restore" the index
Will the restored index have entries for the new values? If so, where would they come from?