Database restore commands

  • Comments posted to this topic are about the item Database restore commands

    M&M

  • Thank you.

    This is a good refresher and important topic.

    Good question

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Basic question on restore. Helpfull to beginners especialy.

  • thanks 🙂

    glad to get 2 points... however had to read the msdn to get the correct answer!

  • Normally there are 3 types while performing restoration,

    1.Leave the database ready to use by rolling back the uncommitted transactions. Additional transaction logs cannot be restored. (RESTORE WITH ----)

    2.Leave the database non-operational, and do not roll back the uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH ----)

    3.Leave the database in read-only mode. Undo uncommitted transactions, but save the undo actions in a standby file so that recovery effects can be reverted. (RESTORE WITH ----)

  • Easy 2 points today! Good question though and a topic that every DBA should be familiar with.

  • Thanks for the 2 points!

    Only 54% correct so far, there's too many devs on this site! So its good they learnt something important 😀 😉

    ---------------------------------------------------------------------

  • 2 points 2 easy. One complaint - your language in the question and for the answer was imprecise. In your answer you said something about basically waiting for a log restore, but you might also want to restore with norecovery on the full backup because you want to apply a differential restore.

  • george sibbald (3/18/2010)


    Thanks for the 2 points!

    Only 54% correct so far, there's too many devs on this site! So its good they learnt something important 😀 😉

    LOL

    Thanks George

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Toby White (3/18/2010)


    2 points 2 easy. One complaint - your language in the question and for the answer was imprecise. In your answer you said something about basically waiting for a log restore, but you might also want to restore with norecovery on the full backup because you want to apply a differential restore.

    Thanks, I agree. Even I got confused when I read the question today 😀

    I will try next time, to present more clearly.

    M&M

  • george sibbald (3/18/2010)


    Thanks for the 2 points!

    Only 54% correct so far, there's too many devs on this site! So its good they learnt something important 😀 😉

    You wouldn't have anything to do without us "devs". :w00t:

  • Define 'developer'...:-P

  • Paul White NZ (3/30/2010)


    Define 'developer'...:-P

    people what code but can't restore databases! :-):-D;-)

    ---------------------------------------------------------------------

  • george sibbald (3/30/2010)


    Paul White NZ (3/30/2010)


    Define 'developer'...:-P

    people what code but can't restore databases! :-):-D;-)

    I called myself a Database Developer for many years...:-P

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply