does backup and restore use tempdb?

Question

does backup and restore use tempdb?

Siten0308

SSCarpal Tunnel

Points: 4409
More actions
January 9, 2018 at 8:28 am

#334463

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

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

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

Sue_H SSC Guru Points: 90860 More actions · Answer 1

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

Siten0308 SSCarpal Tunnel Points: 4409 More actions · Answer 2

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

thanks again

Jeff Moden SSC Guru Points: 1004475 More actions · Answer 3

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)

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

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.

Jeff Moden SSC Guru Points: 1004475 More actions · Answer 5

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)

Arsh SSCertifiable Points: 6354 More actions · Answer 6

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.