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.
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.
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 [].
