Home Forums Career Employers and Employees Answers to these questions RE: Answers to these questions

  • May 30, 2012 at 12:04 pm

    #1494821

    SKYBVI (5/25/2012)

    Hi,

    I have been studying SQL Server DBA interview questions from the net and find these questions in wich I am unclear of the solutions :-

    1) If a database goes down for whatever reason (assume data file is corrupt) and the database cannot be brought back online (i.e. you are in a recovery situation), what must be done first to ensure you can retrieve the latest data modifications assuming the database is set to the FULL recovery model?

    ans :- meanwhile connect to the log shipping server.

    2) What can you do to guarantee any backup is valid?

    ans :- restore verifyonly from backup

    Just looking at these two questions, and the answers you've posted, I would be very very careful about just accepting these answers blindly. Question one makes particular assumptions about a business's environment setup and question two... Wow. I can count three ways (right now) that that assumption can get a person fired.

    If you want to interview for a DBA position, I suggest buying a developer copy and playing with it until you break several things. Because I would not hire someone who answered those questions with those answers.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.