SQL Server Performance

Hi gurus.

Discussion in 'Performance Tuning for DBAs' started by lara99, Nov 12, 2007.

  1. lara99 New Member

    Hi guys I want to reindex all tables in my database but the problem is if some thing is messed up i want to
    go to previous index structure, now here very basic question as i am little new to sql server will restoring
    a backup of the databases brings up the old indexes or I dont now can you guys please guide me how it works.
    Any helpw will be appreciated.
  2. ndinakar Member

    Yes you can back up your entire db and start the reindex. If something gets messed up (which I am not sure what you mean by it), you can restore the backed up copy.
  3. satya Moderator

    Think about other updates, when you restore those will be gone too.
    In this case if the reindexing has done something you don't want, you can change or modify relevant indexes to correct them again. So restore is only final option where you have no choice to go back to good old data, in general on a production server you shouldn't think about it frequently [:)].

Share This Page