Home » Blog » Reply » Reply To: Does tempdb.mdf Size Get Affected By the Recovery Model Of a Database?

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

Lincoln Burrows ~ Modified: August 4th, 2015 ~ ~ 1 Minute Reading

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

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.