When restoring a table with a filtered index using Object Level Recovery, the filtered index is restored but missing the WHERE clause, rendering the filtered index as a nonfiltered index.
Generated by OLR:
CREATE INDEX [IX_Filtered] ON [dbo].[OLR_Test]
You need to be signed in and under a current maintenance contract to view premium knowledge articles.