tempdb log file restricted

• ericwenger1

  Hall of Fame

  Points: 3436

  More actions

  May 31, 2018 at 11:30 am

  #348422

  I'm looking at an issue where the creator of this instance decided to make the tempdb log file restricted instead of unlimited. I've tried to go in via SSMS to change it from restricted to unlimited but it doesn't appear to be changing.
  I even looked in sysfiles. I have been able to modify the size to enlarge it but I would prefer to make it unlimited.  Any ideas? Thanks

• Chris Harshman

  SSC-Forever

  Points: 42192

  More actions

  May 31, 2018 at 12:58 pm

  #1992539

  Unlimited has never really been truly unlimited.  The current definition can be found in the MAXSIZE section of this page:
  https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-file-and-filegroup-options?view=sql-server-2017
  Do you really need a TEMPDB transaction log of larger than 2 TB?