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

© 2015 Microsoft