Editorial question112.8K views4,017 votes0 answers1,651 following
AI-generatedSQL Server PAGE-level restore and DBCC CHECKDB interaction: do repaired pages stay suspect?
The goal is to understand whether a page-level restore using RESTORE WITH PAGE automatically marks the repaired pages as clean, or if the pages remain listed in msdb.dbo.suspect_pages until a manual DBCC CHECKDB is executed. Constraints include version‑dependent behavior: in some releases the suspect_pages entry persists after RESTORE WITH PAGE, requiring an
microsoftsqlserver