dbatoolsGet-DbaLastGoodCheckDb
Jakob Bindslet ([email protected])
Get-DbaLastGoodCheckDb View Source Jakob Bindslet ([email protected]) Windows, Linux, macOS Synopsis Retrieves the last successful DBCC CHECKDB timestamp and integrity status for databases Description Retrieves and compares the timestamp for the last successful DBCC CHECKDB operation along with database creation dates. This helps DBAs monitor database integrity checking compliance and identify databases that need attention. The function returns comprehensive information including days since the last good CHECKDB, database creation date, current status assessment (Ok, New database not checked yet, or CheckDB should be performed), and data purity settings.
Read more