Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a few different instances (SQL 2000, 2005) with indexes placed in a separate filegroup. Do i need to ensure that this group is backed up, or will it be rebuilt by a restore of of the database?

share|improve this question
up vote 6 down vote accepted

The first point to consider that a clustered index is actual table data. So in that alone, I'd say yes. Your whole database should be backed up and able to restore (there are a few exceptions to that, like read only filegroups that are subject to no DML).

The second point is that restoring a database does not rebuild or reorganize any indexes.

So yes, you should be backing up all of your data, indexes included.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.