sql-server-maintenance-solution

sql-server-maintenance-solution copied to clipboard

Changes for FR #522

Rob-S

@CleanupMode = 'BEFORE_BACKUP' - linux not working

1

I have on Linux MSSQL 2019, latest version of the maintenance script. Script date: Script Date: 11. 05. 2021 07:43:20 I am trying to do a backup and before backup...

alenloncaric

New Error Running IndexOptimize

3

**Description of the issue** IndexOptimize ends in error **SQL Server version and edition** Microsoft SQL Server 2019 (RTM-CU9) (KB5000642) - 15.0.4102.2 (X64) Jan 25 2021 20:16:12 Copyright (C) 2019 Microsoft...

eriund

Output File Clean Job Does NOT support UNC Path

1

**Description of the issue** Output file Clean up job. I can backup to UNC path but this job doesn't support UNC path. **SQL Server version and edition** Microsoft SQL Server...

asjacket

CleanupTime not deleted backup files for databases that no longer exist

3

**Description of the issue** I have configured my FULL and DIFFERENTIAL backup jobs to clean up files older that 168 jours, but have noticed that when a database is deleted...

jrbilodeau

For information after deploy the new script IndexOptimize, we see that update statistics not occur with these parameters : @UpdateStatistics nvarchar(max) = 'ALL', @OnlyModifiedStatistics nvarchar(max) = 'N', @StatisticsModificationLevel int =...

bibi92

**Description of the issue** When there is a columnstore index on a table all the other (rowstore) indexes on the table are rebuilt offline. This behavior has no reason because...

LukasMakovicka

**Description of the issue** The scheduled index maintenance job utilizing the IndexOptimize procedure is failing **SQL Server version and edition** SQL Server 2017 (RTM-CU18) (KB4527377) - 14.0.3257.3 Enterprise **Version of...

rishikeshdba

The persist_sample_percent parameter will allow all future statistics updates to use the same sample rate, including automatically updated ones. Without this parameter future updates could modify the sample rate. If...

bdollar88

Add option to suppress informational logging in IndexOptimize

2

**Description of the feature** Add new input parameter for Verbosity so we can suppress the "RAISERROR(@EndMessage,10,1) WITH NOWAIT" messages

RoseateSpoonbill