Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Rebuild using Resumable is not allowed for filtered index #838

Open
KMD-jcu opened this issue Nov 18, 2024 · 0 comments
Open

Rebuild using Resumable is not allowed for filtered index #838

KMD-jcu opened this issue Nov 18, 2024 · 0 comments

Comments

@KMD-jcu
Copy link

KMD-jcu commented Nov 18, 2024

Description of the issue

When using the option

@Resumable='Y'

The script generates sql to rebuild the index using resumable syntax - very nice! But this syntax is not allowed on filtered indexes,

SQL Server version and edition
Microsoft SQL Azure (RTM) - 12.0.2000.8 Jul 2 2024 15:39:01 Copyright (C) 2022 Microsoft Corporation

Version of the script


--// Source: https://ola.hallengren.com //--
--// License: https://ola.hallengren.com/license.html //--
--// GitHub: https://github.com/olahallengren/sql-server-maintenance-solution //--
--// Version: 2020-12-31 18:58:56 //--

What command are you executing?

EXECUTE [dbo].[IndexOptimize]
@databases = 'USER_DATABASES',
@LogToTable = 'Y',
@indexes = 'ALL_INDEXES',
@MaxDOP = 4,
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REBUILD_ONLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@UpdateStatistics = 'ALL',
@OnlyModifiedStatistics = 'Y',
@Resumable='Y'

What output are you getting?
Rebuild using Resumable is not allowed for filtered index... (cannot find the exact words....)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants