does backup and restore use tempdb?

  • Good morning,

    again stupid novice question, but when taking a backup and/or restore, does it ever use tempdb? if so, how and can you explain the process?

    thanks in advance

  • Siten0308 - Tuesday, January 9, 2018 8:28 AM

    Good morning,

    again stupid novice question, but when taking a backup and/or restore, does it ever use tempdb? if so, how and can you explain the process?

    thanks in advance

    Unasked questions are the stupid ones.
    But no it won't use tempdb. If you are wanting to understand more details of the process, check the following articles:
    Understanding SQL Server Backups

    And this is a good reference when you start searching on it and reading different posts, articles:
    A SQL Server DBA myth a day: (30/30) backup myths

    Sue

  • cool big thanks, this helps a lot, now to tell a So called Senior DBA that it doesnt use tempdb 😛

    thanks again

  • Siten0308 - Tuesday, January 9, 2018 8:47 AM

    cool big thanks, this helps a lot, now to tell a So called Senior DBA that it doesnt use tempdb 😛

    thanks again

    Careful, now.  The head you hand someone may be your own. 😉

    There is nothing in the links that Sue posted that proves what she said (although I'm sure she's absolutely correct but I have no actual proof myself) and you can't actually tell someone that they're wrong when you have no actual proof.

    Rather than pissing off your DBA by saying something that you can't prove, ask the DBA for proof that it uses TempDB either in a Microsoft White Paper, Books Online, or by someone's verifiable and repeatable test code from some blog or whatever.  If the DBA can't prove it, then the DBA will hopefully learn a lesson about not saying something so confidently without some form of proof.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Jeff Moden - Tuesday, January 9, 2018 4:56 PM

    Siten0308 - Tuesday, January 9, 2018 8:47 AM

    cool big thanks, this helps a lot, now to tell a So called Senior DBA that it doesnt use tempdb 😛

    thanks again

    Careful, now.  The head you hand someone may be your own. 😉

    There is nothing in the links that Sue posted that proves what she said (although I'm sure she's absolutely correct but I have no actual proof myself) and you can't actually tell someone that they're wrong when you have no actual proof.

    Rather than pissing off your DBA by saying something that you can't prove, ask the DBA for proof that it uses TempDB either in a Microsoft White Paper, Books Online, or by someone's verifiable and repeatable test code from some blog or whatever.  If the DBA can't prove it, then the DBA will hopefully learn a lesson about not saying something so confidently without some form of proof.

    Sage advice from the Sage himself.

  • Lynn Pettis - Tuesday, January 9, 2018 5:35 PM

    Jeff Moden - Tuesday, January 9, 2018 4:56 PM

    Siten0308 - Tuesday, January 9, 2018 8:47 AM

    cool big thanks, this helps a lot, now to tell a So called Senior DBA that it doesnt use tempdb 😛

    thanks again

    Careful, now.  The head you hand someone may be your own. 😉

    There is nothing in the links that Sue posted that proves what she said (although I'm sure she's absolutely correct but I have no actual proof myself) and you can't actually tell someone that they're wrong when you have no actual proof.

    Rather than pissing off your DBA by saying something that you can't prove, ask the DBA for proof that it uses TempDB either in a Microsoft White Paper, Books Online, or by someone's verifiable and repeatable test code from some blog or whatever.  If the DBA can't prove it, then the DBA will hopefully learn a lesson about not saying something so confidently without some form of proof.

    Sage advice from the Sage himself.

    Heh... maybe not a Sage.  Maybe a survivor of such conversations on both ends of that stick.  Being wrong in my younger days taught me well.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Jeff Moden - Tuesday, January 9, 2018 4:56 PM

    Careful, now.  The head you hand someone may be your own. 😉

    Million(shall I say Billion ?) dollar advice from Jeff. Very real and thought-provoking for any budding professional in his professional life , and even personal.

Viewing 7 posts - 1 through 6 (of 6 total)

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