Online Restore and Disabled Indexes

Icon showing a blue database disk This topic is relevant only for databases that have multiple filegroups and, for the simple recovery model, at least one read-only filegroup.

If a database is online, the index can be created, dropped, enabled or disabled only if all filegroups holding any part of the index are online.

See Also

Concepts

Indexes
Performing Online Restores

Help and Information

Getting SQL Server 2005 Assistance