Tempdb database

[jrprogr]

Hi My tempdb database data file is very large, does somebody know how can I free up resources? I have already stopped and restarted sql server

 

[mrdenny]

When you stop and restart SQL the tempdb database is dropped and recreated. If someone increated the size of the files by using the alter database command the database would be large every time the server is restarted.

You can try shrinking the database via the DBCC SHRINKDATABASE command.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLBill]

As MrDenny stated, check the default size of TEMPDB.

In Enterprise Manager, expand until you see the databases.

Right click on TempDB, select Properties. Go to the Data tab and Log tab. See what size they are set for.

Do the same for the Model database. I believe that when you restart the services, TEMPDB is rebuilt from the Model defaults. If the default sizes for Model are large, change their sizes and restart the services. See if that solves the issue.

You probably could run the ALTER DATABASE command to change the size of TEMPDB.

-SQLBill

Posting advice: FAQ481-4875