Rehearse page restore on a test database, identify damaged page IDs, apply the backup chain, and verify storage and database consistency.
Backing Up MySQL, Explained for SQL Server DBAs
Backing up MySQL means choosing logical or physical copies and retaining binary logs for point-in-time recovery, then testing restores.
Checking Data Type Mapping After a Database Migration
Audit data type mapping after migration, compare counts and checksum screens, inspect length and precision, and reconcile changed values.
Disabling All Agent Jobs During a Freeze and Restoring Their State
Enable-all after a freeze wakes up jobs that were off on purpose. Save the starting state and put back exactly that.
A Server Trigger That Blocks Accidental Database Drops
A server trigger can turn a wrong-tab DROP DATABASE into an error message. Here is a small demo that guards one name and removes itself at the end.
Rebuilding System Databases With Setup When master Is Lost
Plan rebuilding system databases with Setup when master has no usable backup, then restore logins, jobs, and configuration.
Measuring Space Used by Tables per Filegroup in T-SQL
Measure tables per filegroup from allocation metadata, include LOB and overflow pages, and separate partition placement from growth history.