Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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.

Community Additions

ADD
Show:
© 2015 Microsoft