Blog Post

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!

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating