I back up databases by using the SQLS wizard (Sequel Server 2005). Occasionally, I need to restore the backup onto a different computer. When I do this, all indexes are present but I have noticed that performance tends to be quite slow. I am wondering if the indexes are actually working under this scenario - that is, if an indexed table generated on computer x is backed up and then restored to computer y, will the indexes still work properly or should I drop and re-create them?

Thanks.

Chris

Hi,

You should check the execution plan and need to update the statistics or defrag the index or rebuild the index if needed.

If the both servers hardware & software is different then it is better to peform a reindex & update statistics on the database when it is restored.

 Thanks - both computers are running SQLS 05 but the OS's are different and the hardware specifications are different too.

May I add a question about statistics? Where are stats held? - Are they part of the database on which they have been compiled or are they held in a system database? Would statistics be part of the backup?

Chris

Yes the statistics are stored as system objects in the user databases, but due to the mismatch of system configuration this is useless and in order to gain them you need to perform REINDEX or UPDATE STATISTICS if there is any small change in configuration of hardware or software.

 Many thanks - I will incorporate these measures into my work plans from now on.

Chris