Object Level Recovery restoring filtered indexes missing index WHERE clause (205203)

Chat now with support

Return

Title

Object Level Recovery restoring filtered indexes missing index WHERE clause
Description

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:
CREATE INDEX [IX_Filtered] ON [dbo].[OLR_Test]
(
[Value] ASC
)
WHERE ([Value]>(50))
WITH (PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON
)
ON [PRIMARY]
GO

Generated by OLR:
CREATE INDEX [IX_Filtered] ON [dbo].[OLR_Test]
(
[Value] ASC
)
WITH (PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON
)
ON [PRIMARY]
GO

Sign In Required

You need to be signed in and under a current maintenance contract to view premium knowledge articles.