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.
e.g.
Original:
GO
Generated by OLR:
CREATE INDEX [IX_Filtered] ON [dbo].[OLR_Test]
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy