sql-server-maintenance-solution

sql-server-maintenance-solution copied to clipboard

DatabaseIntegrityCheck script on msdb failing - dbcc checkdb does not

16

**Description of the issue** DatabaseIntegrityCheck script outcome failed for msdb database and some user databases when @ExtendedLogicalChecks = 'Y'. DBCC CHECKDB ([msdb]) WITH NO_INFOMSGS, ALL_ERRORMSGS, EXTENDED_LOGICAL_CHECKS succeeds. **SQL Server version...

e11ameno

Missing entries in "msdb.dbo.backupset" for user databases in an AG

5

Hey Ola, hope you are doing fine :) So my problem is that our monitoring system "Checkmk" is not able to determine the date & time of user databases that...

denniskrispliebherr

Unable to use the restore procedure with the latest commandexecute stored proc by Ola

3

hi Sir, I am trying to use this stored procedure for restore for ola backups but it throws the below error Msg 201, Level 16, State 4, Procedure CommandExecute, Line...

sindu1489

IndexOptimize not logging to table CommandLog

1

**Description of the issue** IndexOptimize not writing to Log table when used as TSQL (vs SQLCMD) **SQL Server version and edition** Execute ```SELECT @@VERSION``` Microsoft SQL Server 2019 (RTM-CU16-GDR) (KB5014353)...

poupster2

Deleting Encrypted Backup Files

1

So this isn't an issue that is likely fixable, but one that probably needs listing on the FAQs. If you encrypt your backup files to disk then xp_delete_file can't read...

NickColebourn

Moving the SQL Server Maintenance Solution to its own schema?

66

I am thinking about moving the SQL Server Maintenance Solution to its own schema. The background for this, is that I am planning to introduce some new objects, and as...

olahallengren

Allow generic threading so IndexOptimize can run in arbitrarily many jobs

1

There's currently a parameter in IndexOptimize that allows you to thread between databases. This can be generalized to allow threading even within a database, or even schema. The only necessary...

RickPuig

IndexOptimize: Heap (de)fragmentation

8

Feature request - adding the ability to identify and "fix" heap fragmentation. I know a heap is usually a bad idea and that heap maintenance is a pain, but there...

blazdax

Backup cleanuptime cannot be changed when using @modificationlevel

1

I am doing DIFF backups unles the modification level is above a certain treshold. DIFF backups should only last for 24 hours, FULL backups for 2 weeks. However, I cannot...

wfvdijk

Please add support to look at the newer database options for ELEVATE_ONLINE and ELEVATE_RESUMABLE. It's a whole lot easier to set those than to alter every index.

speedy32129