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…
Tag: REPAIR_ALLOW_DATA_LOSS
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…