Printed 2017/07/27 03:30AM

Insufficient Space for a Side by Side Restore - What Do You Do?

By Andy Warren, 2008/08/28

I was recently working with a student in a one on one format and one the scenarios he wanted to learn to handle in SQL Server (he was an Oracle DBA cross training) was how to recover from the proverbial accidentally dropped table when there wasn't enough space to do a parallel restore and then move the missing object/data back to the original database. Have to say I'd never been in the situation where I didn't have the disk space for that, and of course the challenge is that even though you have missing data, you also typically have a lot of good data you don't want to lose.

What do you do? (humor for today)

Here's the steps:

It can be a little more complicated if multiple objects were affected, say in the case of a foreign key with cascading deletes enabled, but the overall process stays the same. Time to recover is basically 2X what it should be if you had space available on that server or another one.

Maybe something to think about and bake into your next DR practice session.



Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.