Video – Recovering data with crash consistent snapshots

A while back I posted a blog on how to recover data with crash consistent snapshots.

Snapshots are pretty handy in certain situations so I thought I’d show you them in action!

In the video below I’m being a little bit more dramatic than in the blog post 🙂

What I’m going to do is: –

  1. Take a crash consistent snapshot of the AdventureWorks database volumes
  2. Corrupt a table in the database with DBCC WRITEPAGE
  3. Overwrite another volume on the server with the snapshot taken
  4. Attach a copy of the AdventureWorks database to the SQL instance
  5. Retrieve the data in the table from the newly attached database

Here we go!

Thanks for watching!

Leave a Reply

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

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

Facebook photo

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

Connecting to %s