HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Is it imperative that I backup my index files?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
filesimperativethatindexbackup

Problem

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?

Solution

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.

Context

StackExchange Database Administrators Q#18686, answer score: 6

Revisions (0)

No revisions yet.