SQL Homework – April 2019 – Practice dealing with corruption

Leave a comment

April 3, 2019 by Kenneth Fisher

Over the last almost 2 years (wow how time flys when you are having fun) we’ve practiced all kinds of common tasks from installing a SQL Server instance, to creating tables and views. Maybe now is a good time to practice a few things that are equally important, but maybe less common. So to start with, let’s practice handling some database corruption.

A while back Steve Stedman (b/t) did a series he called the Database Corruption Challenge. Try a couple.

Now, you may not be able to solve them on your own. I know I’ve had a hard time myself now and again and that’s fine. This is a learning exercise. Fortunately, in this case, each of the challenges has a set of solutions that others came up with. So if you have a hard time recovering the corrupted data, go back and read them. In most cases, there is more than one way to recover from corruption so honestly, it wouldn’t hurt to read them regardless.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: