It is suggested for tempdb, there should not be any maximum size select
autoextend.
It will automatically reduce its size when the task is completed.

-----Original Message-----
From: Rob Haughian [mailto:rob.[Email Address Removed] Wednesday, September 17, 2003 11:41 AM
To: LazyDBA.com Discussion
Subject: Logging for tempdb


Lately I have been having problems with tempdb filling up. I have the size
set for a maximum of 1500 mb. I am wondering what should the logging be set
for temppdb?

Rob Haughian
Saskatchewan Assessment Management Agency (SAMA)
200 - 2201 - 11th Avenue
Regina, SK, S4P 0J8
Phone: (306) 924-6603

MS Sql Server LazyDBA home page