Nov 11 2024 32 mins 37
Guy and Eitan discuss the common challenge of long-running database integrity checks (DBCC CHECKDB) and a solution to resolve it, and why do we need integrity checks at all?
Relevant links:
- PASS Data Community Summit
- Incremental Integrity Check for Large Databases - Eitan Blumin's blog
- SQL Server Integrity Check - by Ola Hallengren
- tigertoolbox/MaintenanceSolution/5_job_Maintenance.sql · microsoft/tigertoolbox
- sp_can_tlog_be_applied (Transact-SQL) - SQL Server | Microsoft Learn
- T-SQL Script to Roll Forward Transaction Log Backups - Eitan Blumin's blog