General SQL Database Repair for Enterprise Applications

Physical corruption happens on all platforms with any Relational Database Management System (RDBMS).    Data is persisted on disks.   Disks exist in nature.   Natural, man-made, and environmental disasters happen.   This blog post is targeted for when  corruption is encountered in SQL Server databases.   Should this happen?  Ideally: No.  Never.   Does it happen?   Yes.  Still.   Isn’t technology…


Take Caution and Consider well before using RADL or LOGREBUILDING

The purpose of this post is to discourage the use of RADL or LOGREBUILDING when corruption is encountered without understanding the impact.  Unfortunate situations have been encountered where Database Administrators (or “experts” assisting them) have chosen to use them without grasping the effects of that decision.   Sometimes the BACKUP strategy and Backup validation process…