Does tempdb.mdf Size Get Affected By the Recovery Model Of a Database?
Stephen West ~
Modified: August 3rd, 2015 ~ ~ 1 Minute Reading
- This topic has 1 reply, 2 voices, and was last updated 9 years, 8 months ago by .
Viewing 1 post (of 1 total)
-
Posts
-
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.
Viewing 1 post (of 1 total)
- You must be logged in to reply to this topic.