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…

0

Salvaging Data from Corrupt Database Tables

Every Relational Database Management System (RDBMS) can experience corruption.   Data corruptions very rarely occur.   But they do, and they will.    More on database corruptions and consistency can be found HERE.  Restoring from a known good clean backup is always the recommended way to move away from a corrupted database state and back to normal operations.    …

0

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…

0

Consistency and Corruption in Enterprise Databases

One topic that is frequently avoided or trivialized, unless it is personally affecting you, is database corruption.   It is not a pleasant topic to consider.   But expanded awareness can be valuable when handling corruption situations. For this blog post, “consistency” and “corruption” are used as antonyms to each other.   i.e. When data is consistent or…

0