Home » Topic » Does tempdb.mdf Size Get Affected By the Recovery Model Of a Database?

Does tempdb.mdf Size Get Affected By the Recovery Model Of a Database?

Stephen West ~ Modified: August 3rd, 2015 ~ ~ 1 Minute Reading

Home › Forums › Does tempdb.mdf Size Get Affected By the Recovery Model Of a Database?

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • August 3, 2015 at 11:09 am #419 Score: 0
    Stephen West
    Moderator
    4 pts

    I have a database which involves a lot of processing and bulk inserts. I am having problems with the tempdb file growing to extremely large sizes (over 60 GB). The database in question is set to Full Recovery. Will changing it to Simple Recovery prevent it from using the tempdb on these large inserts and bulk loads?

    August 4, 2015 at 10:38 am #423 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    The tempdb is a ‘processing’ part of the database in SQL Server which includes: static cursors, table variables, temp tables, sort operations and other worktable backed query operators, large variables and parameters. So the recovery mode doesn’t affect to the tempdb.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.