Attempt to fetch logical page (1:37241) in database 5 failed. It belongs to allocation unit 72057594046054400 not to 72057594051952640."

1. Run DBCC CHECKDB

This is the built-in tool to diagnose and sometimes fix corruption.

Run this command in SSMS:

DBCC CHECKDB (YourDatabaseName) WITH NO_INFOMSGS, ALL_ERRORMSGS;

Look for the output — it’ll tell you the type and extent of corruption.

2. Try to Repair (if needed)
After running DBCC CHECKDB, if it suggests repair, you can try:

-- Set to SINGLE_USER mode to allow repair
ALTER DATABASE YourDatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

-- Attempt repair
DBCC CHECKDB (YourDatabaseName, REPAIR_ALLOW_DATA_LOSS);

-- Back to MULTI_USER mode
ALTER DATABASE YourDatabaseName SET MULTI_USER;


⚠️ Warning: REPAIR_ALLOW_DATA_LOSS can remove corrupted data. Only use it if you have no backups.


🛡️ Best Practice: Restore from Backup
If possible, restore a recent backup of the database taken before the corruption happened. That’s the safest and cleanest way.


 Additional Tips


Identify the object using this command (replace page and db name):

DBCC TRACEON (3604);
DBCC PAGE (YourDatabaseName, 1, 37241, 3);

This may help figure out which table/index is affected.
Need Help Fixing It?