Home Forums SQL Server 2008 SQL Server Newbies does backup and restore use tempdb? RE: does backup and restore use tempdb?

  • January 9, 2018 at 8:44 am

    #1975091

    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