Skip to content

SQL Server

Week 5 – Alternate Solution

Here is how I solved Week 5 of the Database Corruption Challenge. The following steps were tested and confirmed working on SQL Server 2008R2, SQL Server 2012, and SQL Server 2014.

 

To oversimplify, here are the steps:

  • Restore the last known good database.
  • Shut down the database, and copy off the last good database files.
  • Replace some files and restart it. (Hack Attach)
  • Next realizing that the boot page was corrupt page 1:9.
  • Shut down the database.
  • Copy the boot page from the last good database files and place it in the corrupt file.
  • Restart the database.
  • Realize there is other corruption.
  • Fix the other corruption.

Read More »Week 5 – Alternate Solution

An Awesome Day at SQL Saturday Redmond

SQLSat393RedmondBadge

Yesterday was SQL Saturday Redmond. It was a great day, I learned lots, met some great new people, and had a chance to catch up with some old friends. When most people hear about SQL Saturday for the first time, they probably think to themselves “spend all day on a Saturday in technical presentations”, however SQL Saturday is much more than that. The presentations all all great, don’t get me wrong here, but the biggest value that I see is in the people that you get to know, and the things you can learn from the vendors. There were at least 6 people that I know online through Twitter, Fitbit, LinkedIn and other online sites that I had the opportunity to meet in person for the first time this weekend.

SQLSat393FriendsPicture Credit: Thanks Jimmy May (@aspiringgeek)

Read More »An Awesome Day at SQL Saturday Redmond

When Corruption Strikes – Online Presentation Wed May 13th

On Wednesday May 13th I will be presenting to the PASS DBA Virtual Chapter Meeting, at Noon Mountain time (convert to your time zone).

The session is titled “When Database Corruption Strikes“, and the event has been sponsored by Dell Software

Abstract:

You are working along month after month with no problems in your database. Suddenly someone reports that their query won’t run. They get an error stating “SQL Server detected a logical consistency-based I/O error”, or something even scarier. Do you know what to do now? We will walk through 3 or 4 actual corrupt databases exploring ways to go about finding and fixing the corruption. More importantly we will explore how to prevent further data loss at the time corruption occurs. Learn what things you should do to protect yourself when corruption strikes. Learn what to avoid that will make things worse. You will leave with a checklist of steps to take when you encounter corruption. By the end of this session you will be ready to take on corruption, one database at a time.

Read More »When Corruption Strikes – Online Presentation Wed May 13th