SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Interview Question
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sophie1
Starting Member

17 Posts

Posted - 03/15/2014 :  11:29:19  Show Profile  Reply with Quote
Hello ,
Can anyone here answer this question Please?

A DBA accidentally dropped a critical highly transactional table in production. Walk me through the exact procedure to restore it without taking the application offline.

sophie1
Starting Member

17 Posts

Posted - 03/15/2014 :  23:40:01  Show Profile  Reply with Quote
looks like everyone is enjoyng weekend :)
Go to Top of Page

nagarjuna_a2006
Starting Member

India
13 Posts

Posted - 03/16/2014 :  08:24:46  Show Profile  Reply with Quote
Hi,

I think up to my knowledge we cannot restore it back

let us see if any one post the answer for this kind of problems.

Regards,
Nagarjuna
Go to Top of Page

denis_the_thief
Aged Yak Warrior

Canada
591 Posts

Posted - 03/17/2014 :  13:58:36  Show Profile  Reply with Quote
I would restore the whole database to another machine (or temporary database), then copy the table by scripting it out.

Edited by - denis_the_thief on 03/17/2014 13:58:52
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 03/17/2014 :  14:02:45  Show Profile  Visit tkizer's Homepage  Reply with Quote
1. Update resume
2. Update Linkedin
3. Contact head hunters
4. Restore database with different name or to different server
5. Copy table from restored database into prod database
6. Add any dependent objects such as foreign keys
7.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 03/24/2014 :  13:54:41  Show Profile  Reply with Quote
I'd get the DBA to do it - after all HE dropped it!!

Ah, hang on. He's gone and now I am the DBA?
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1677 Posts

Posted - 04/16/2014 :  19:24:36  Show Profile  Reply with Quote
In re: #7 - Hilarious....

===============================================================================
“Everyone wants a better life: very few of us want to be better people.”
-Alain de Botton
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1677 Posts

Posted - 04/17/2014 :  11:53:40  Show Profile  Reply with Quote
I couldn't stop thinking about this last night and came up with:
1. (Minor point but c'mon) A "critical highly transactional table" has been dropped yet the application is still running....?
2. You can't just take an earlier backup since you'd lose data. You'd want to do a point in time restore, if possible.
3. To get restored the quickest, wouldn't you want to consider a Filegroup restore. It may be too messy depending on what else is in the filegroup and what data may have changed.
4. Perhaps the most important of all, find the person who recently left the company and blame the whole thing on them! Mention that you had warned people that this was gonna happen and that to prevent it you'll need additional authority and a MUCH larger budget!!!

===============================================================================
“Everyone wants a better life: very few of us want to be better people.”
-Alain de Botton

Edited by - Bustaz Kool on 04/17/2014 12:00:15
Go to Top of Page

TG
Flowing Fount of Yak Knowledge

USA
6062 Posts

Posted - 04/17/2014 :  13:51:05  Show Profile  Reply with Quote
The correct response to this interview question is one of these two depending on if you want the job or not:

- If you hire me that scenario would NEVER happen.
or
- <standing up> Thank you for considering me but I would never work for a company where such incompetency exists.

Be One with the Optimizer
TG
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1677 Posts

Posted - 04/17/2014 :  14:36:00  Show Profile  Reply with Quote
With apologies to Groucho Marx...

I would never work for any company that would have someone like me as an employee.

===============================================================================
“Everyone wants a better life: very few of us want to be better people.”
-Alain de Botton
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.45 seconds. Powered By: Snitz Forums 2000