Hi,

Friends I solved tempdb db (mdf) size grow problem by following
steps:

1) Restart SQL Server ; Connect the database in single user mode

2) use tempdb

Go

Dbcc shrinkfile (tempdev, 'target size in MB')

Go

Dbcc shrinkfile (templog, 'target size in MB')

Go

This command shrinks the primary data file.

For tempdb log file grows a simple sqlservice restart is enough. IF
suddenly your datafile (mdf) growth was huge then we have to restart the
service and then we have to connect it thru single-user mode. After that
we have to shrink the file to reduce the tempdb size.

If you overcome the same problem follow the above procedure. It will
help you.



Thanks & Regards

Venkat



________________________________

From: Venkataramani S.
Sent: Friday, March 28, 2008 1:35 PM
To: '[Email address protected]
Subject: tempdb datafile size grows to 90 gb



Hi,

I got this error message in my log file.

"Autogrow of file 'tempdev' in database 'tempdb' took 64328
milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH
for this file."

Suddenly my temp db datafile size grows to 90 gb. I have enabled auto
growth. When I checked the spaceused it used only 2 mb and remaininig in
unallocated zone.



I did shrink database and shrinkfile to reduce it to default size but
nothing happened.





Pls friends help me out in this issue. very urgent I am running out of
space.



Thanks in advance



Venkat


MS Sql Server LazyDBA home page