MsSQLServerDBA comments

Repositories
Issues
Comments

Results 2 comments of


                                            MsSQLServerDBA

DatabaseIntegrityCheck script on msdb failing - dbcc checkdb does not

On SQL 2019 CU16, OLA's script: EXECUTE [dbo].[DatabaseIntegrityCheck] @Databases = 'msdb', @CheckCommands = 'CHECKDB', @ExtendedLogicalChecks ='Y',@LogToTable = 'Y' returns the following with error number 2706: Command: DBCC CHECKDB ([msdb]) WITH...

DatabaseIntegrityCheck script on msdb failing - dbcc checkdb does not

Yes, I did see and test your example. So the trace flag skips all stats checks in order to bypass the TVFs. Ola's script fails because of the way it's...