Repair Strategy

The repair strategy involves repairing corrupt pages while the database is partially offline.

Diagnose and repair problems using known methods, including dbcc commands, running queries with known results against the suspect pages, and calling SAP Technical Support, if necessary. Repairing damage can also include dropping and re-creating objects that contain suspect pages.

You can either use sp_forceonline_page to bring offline pages online individually, as they are repaired, or wait until all the offline pages are repaired and bring them online all at once with sp_forceonline_db.

The repair strategy does not require taking the entire database offline. This figure illustrates the strategy used to repair corrupt pages.

Graphic describing the steps for repairing a corrupt database.