SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


does backup and restore use tempdb?


does backup and restore use tempdb?

Author
Message
Siten0308
Siten0308
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3285 Visits: 455
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
Sue_H
Sue_H
SSC Guru
SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)

Group: General Forum Members
Points: 67020 Visits: 13928
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
Siten0308
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3285 Visits: 455
cool big thanks, this helps a lot, now to tell a So called Senior DBA that it doesnt use tempdb Tongue

thanks again
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (847K reputation)SSC Guru (847K reputation)SSC Guru (847K reputation)SSC Guru (847K reputation)SSC Guru (847K reputation)SSC Guru (847K reputation)SSC Guru (847K reputation)SSC Guru (847K reputation)

Group: General Forum Members
Points: 847162 Visits: 46672
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 Tongue

thanks again


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

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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)SSC Guru (380K reputation)

Group: General Forum Members
Points: 380496 Visits: 42209
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 Tongue

thanks again


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

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.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (847K reputation)SSC Guru (847K reputation)SSC Guru (847K reputation)SSC Guru (847K reputation)SSC Guru (847K reputation)SSC Guru (847K reputation)SSC Guru (847K reputation)SSC Guru (847K reputation)

Group: General Forum Members
Points: 847162 Visits: 46672
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 Tongue

thanks again


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

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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Arsh
Arsh
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4806 Visits: 953
Jeff Moden - Tuesday, January 9, 2018 4:56 PM


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

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.

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search