Question

You administer an Azure SQL Managed Instance hosting a critical order-processing database. Users report intermittent errors referencing a logical consistency-based I/O error on a specific page. Before restoring from backup, you want to confirm whether the database has physical or logical corruption and identify the affected objects. Which action should you take first?

Accepted Answer

Run DBCC CHECKDB with the default options against the database to detect allocation and consistency errors

Answer

Enable automatic tuning so the platform can force a last known good plan and bypass the corrupted pages

Answer

Rebuild all indexes on the database using ALTER INDEX ... REBUILD to clear the corrupted pages

Answer

Query sys.dm_db_index_physical_stats to measure fragmentation on the affected table