The Curious Case of… trying to find an MDF file in a RAW disk

Posted on: April 30, 2019 10:38 am

Disaster recovery 101: Object ID 0, index ID -1, partition ID 0

Posted on: December 1, 2017 11:40 am

Disaster recovery 101: fixing a broken system table page

Posted on: November 21, 2017 3:59 pm

SQLskills SQL101: Why DBCC CHECKDB can miss memory corruption

Posted on: July 19, 2017 12:15 pm

SQLskills SQL101: Practicing disaster recovery

Posted on: June 20, 2017 10:10 am

Why PFS pages cannot be repaired

Posted on: March 5, 2017 4:15 pm

SQLskills SQL101: Dealing with SQL Server corruption

Posted on: February 28, 2017 2:34 pm

Data recovery: investigating weird SELECT failures around corruption

Posted on: December 3, 2015 12:20 pm

Disaster recovery 101: fixing a broken boot page

Posted on: June 23, 2015 12:34 pm

Finding a transaction in the log for a particular user

Posted on: June 3, 2015 11:45 am

Finding a table name from a page ID

Posted on: September 25, 2014 1:42 am

Target and actual SQL Server uptime survey results

Posted on: June 2, 2014 10:05 am

Corruption recovery using DBCC WRITEPAGE

Posted on: February 13, 2014 9:49 am

More on using Transaction SID from the transaction log

Posted on: February 11, 2014 6:54 am

Disaster recovery 101: restore master or rebuild master

Posted on: January 28, 2014 2:13 pm

New online course: Detecting and Correcting Database Corruption

Posted on: September 18, 2013 8:53 am

The Accidental DBA (Day 11 of 30): Backups: Backup Storage and Retention

Posted on: June 11, 2013 8:00 am

The Accidental DBA (Day 10 of 30): Backups: Backup Testing for Validation

Posted on: June 10, 2013 8:00 am

The Accidental DBA (Day 9 of 30): Backups: Essential BACKUP Options

Posted on: June 9, 2013 8:00 am

The Accidental DBA (Day 8 of 30): Backups: Planning a Recovery Strategy

Posted on: June 8, 2013 8:00 am

The Accidental DBA (Day 7 of 30): Backups: Recovery Models and Backup Types

Posted on: June 7, 2013 8:00 am

The Accidental DBA (Day 6 of 30): Backups: Understanding RTO and RPO

Posted on: June 6, 2013 8:00 am

DBCC WRITEPAGE: an introduction

Posted on: February 5, 2013 11:45 am

SQL Server disaster-recovery poster now available

Posted on: February 1, 2013 10:46 am

Corruption demo databases and scripts

Posted on: January 8, 2013 12:29 pm

Importance of how often you take full backups

Posted on: December 21, 2012 11:39 am

Importance of where you store your backups

Posted on: December 21, 2012 6:52 am

When the going gets tough, the tough hide under the table

Posted on: October 29, 2012 11:35 am

Multiple log files and why they’re bad

Posted on: September 24, 2012 3:48 pm

Using fn_dblog, fn_dump_dblog, and restoring with STOPBEFOREMARK to an LSN

Posted on: May 17, 2012 3:05 am

SQL Server Magazine: feature article on using database repair

Posted on: August 25, 2011 11:29 am

Disaster recovery 101: dealing with negative SPIDS (-2 and -3)

Posted on: June 24, 2011 3:19 am

TechNet Magazine article: data protection and the corporate jigsaw puzzle

Posted on: April 6, 2011 11:27 am

Human nature is a significant hurdle to successful disaster recovery

Posted on: March 23, 2011 12:10 pm

Surveys: DR plan testing and considering human nature

Posted on: March 11, 2011 10:14 am

Disaster recovery 101: fixing metadata corruption without a backup

Posted on: March 10, 2011 8:11 am

Updated database size survey results

Posted on: February 22, 2011 1:22 pm

Unbelievable tale of disaster and recovery

Posted on: February 16, 2011 8:18 am

Disaster recovery 101: hack-attach a damaged database

Posted on: June 18, 2010 12:11 pm

Disaster recovery 101: backing up the tail of the log

Posted on: June 18, 2010 9:21 am

Whitepaper on high-availability architectures published

Posted on: June 4, 2010 11:00 am

A SQL Server DBA myth a day: (30/30) backup myths

Posted on: April 30, 2010 9:19 am

Important things for DBAs to consider

Posted on: April 12, 2010 4:31 pm

Sample corrupt databases to play with

Posted on: February 26, 2010 12:02 pm

TechNet Magazine: feature article on recovering from disasters using backups

Posted on: November 5, 2009 8:36 am

Importance of having a good disaster recovery plan

Posted on: September 15, 2009 11:17 am

Survey: what kind of disaster recovery guide do you have?

Posted on: August 26, 2009 1:50 pm

Importance of defining and measuring SLAs

Posted on: May 30, 2009 4:00 pm

Weekly survey: maximum allowable downtime – target and actual

Posted on: May 25, 2009 1:58 pm

Importance of testing your disaster recovery plan

Posted on: May 25, 2009 1:00 pm

Weekly survey: have you ever tested your disaster recovery plan?

Posted on: May 17, 2009 5:38 pm

Misconceptions around database repair

Posted on: May 15, 2009 5:02 pm

A sad tale of mis-steps and corruption (from today)

Posted on: May 12, 2009 8:36 pm

How to get all the corruption messages from CHECKDB

Posted on: May 12, 2009 4:56 pm

Importance of having the right backups

Posted on: May 2, 2009 6:32 am

Weekly survey: what kind of backups do you take?

Posted on: April 27, 2009 2:44 am

Physical database layout vs. database size

Posted on: April 27, 2009 12:21 am

Weekly survey: does size really matter – or is it what you do with it?

Posted on: April 10, 2009 3:05 pm

Is running repair on msdb safe?

Posted on: March 25, 2009 9:02 am

Importance of validating backups

Posted on: March 13, 2009 5:17 pm

TechNet Radio interview on database corruption

Posted on: January 12, 2009 11:00 am

TechEd demo: nonclustered index corruption

Posted on: December 17, 2008 11:03 am

TechEd: 80 minute video of Corruption Survival Techniques presentation

Posted on: December 5, 2008 6:14 am

TechEd demo: corruptions fatal to DBCC CHECKDB

Posted on: November 30, 2008 5:37 pm

Corruption survival techniques – useless?

Posted on: November 25, 2008 11:29 am

Conference corruption demo scripts and example corrupt databases

Posted on: November 24, 2008 11:27 am

Planning a backup strategy – where to start?

Posted on: October 26, 2008 11:13 am

Reminder of why hardware redundancy is a good thing

Posted on: October 19, 2008 2:59 pm

Can the hack-the-suspect-database-into-the-server trick work for corrupt file headers?

Posted on: September 2, 2008 10:08 am

Better behavior with suspect databases in SQL Server 2008

Posted on: September 2, 2008 9:44 am

Creating, detaching, re-attaching, and fixing a SUSPECT database

Posted on: August 29, 2008 7:55 pm

SQL Server 2008: How to rebuild the system databases?

Posted on: August 29, 2008 5:04 pm

Should Microsoft provide a transaction log reader tool?

Posted on: August 26, 2008 12:21 am

SQL Server 2008: Does my database contain Enterprise-only features?

Posted on: August 23, 2008 4:06 pm

Search Engine Q&A #22: Can all page types be single-page restored?

Posted on: August 11, 2008 7:32 pm

How to tell if you have instant initialization enabled?

Posted on: August 11, 2008 7:10 pm

Using the Dedicated Admin Connection to fix Msg 8992: corrupt system tables

Posted on: June 12, 2008 1:42 am

CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete

Posted on: June 9, 2008 3:54 pm

Do backups apply to just digital data? And how many backups should you have?

Posted on: May 18, 2008 1:41 am

HA: Where do you start when choosing a high-availability solution?

Posted on: March 13, 2008 9:14 pm

Search Engine Q&A #17: Split a VLDB into filegroups or smaller databases for backups?

Posted on: March 13, 2008 5:41 pm

Available for download: Our High-Availability hands-on labs and SQL Server 2008 JumpStart materials

Posted on: March 12, 2008 5:23 pm

CHECKDB From Every Angle: Example DBCC CHECKDB run-times

Posted on: February 12, 2008 8:35 pm

Paul and Kimberly interview on RunAs Radio – What’s New in SQL Server 2008?

Posted on: December 12, 2007 6:07 pm

Conference Questions Pot-Pourri #6: How to cope with losing the mirror AND the witness in a mirroring session?

Posted on: November 16, 2007 3:31 am

CHECKDB From Every Angle: Can CHECKDB repair everything?

Posted on: November 16, 2007 2:28 am

CHECKDB From Every Angle: How long will CHECKDB take to run?

Posted on: November 15, 2007 4:22 am

CHECKDB From Every Angle: Tips and tricks for interpreting CHECKDB output

Posted on: November 14, 2007 7:07 am

BACKUP WITH COPY_ONLY – how to avoid breaking the backup chain

Posted on: October 15, 2007 9:37 pm

BACKUP LOG WITH NO_LOG – use, abuse, and undocumented trace flags to stop it

Posted on: October 12, 2007 5:09 pm

SQL Server 2008: Performance boost for Database Mirroring

Posted on: October 11, 2007 12:06 am

Search Engine Q&A #7: Restoring from a backup file containing multiple database backups

Posted on: October 10, 2007 1:35 am

How does daylight savings time affect disaster recovery?

Posted on: October 6, 2007 5:49 pm

EMERGENCY-mode repair: the very, very last resort

Posted on: October 2, 2007 11:26 pm

Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database

Posted on: October 2, 2007 5:20 pm

Corruption: Last resorts that people try first…

Posted on: September 15, 2007 12:29 am

Common bad advice around disaster recovery

Posted on: September 13, 2007 8:05 pm

Example 2000/2005 corrupt databases and some more info on backup, restore, page checksums and IO errors

Posted on: September 4, 2007 8:31 pm