The repair strategy involves repairing the corrupt pages while the database is partially offline. You diagnose and repair problems using known methods, including dbcc commands, running queries with known results against the suspect pages, and calling Sybase 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. Figure 11-2 illustrates the strategy used to repair corrupt pages.
