Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pitmanfan
Starting Member
25 Posts |
 Posted - 2006-09-18 : 03:14:08
|
| hellothe tempdb datafile has grown to 55G. to shrink the file, i have tried running dbcc shrinkfile, restarting the sql service and also rebooting the server. the file still remains at 55G. i thought tempdb was recreated each time the sql server was started. any ideas how i can resize the file?thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-18 : 04:02:36
|
| DO NOT SHRINK TEMPDB - you are liable to corrupt the database!! (unless you take care to use a very narrow set of criteria: http://support.microsoft.com/default.aspx/kb/307487)Yes tempdb should be recreated when SQL Server is restarted, so there is obviously something wrong.Worth just checking that the initial size has not got set to 55GB somehow.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64914http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61440There was a similar case to this which came up on SQL Team a few months, but the OP never reported back what the outcome was:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64403raising your issue in the DB Corruption Forum will get Paul's input (although I think hes at TechEd or somesuch for the next few weeks)You probably also need to optimise/fix whatever process caused it to grow to 55GB - otherwise its only going to happen again!Kristen |
 |
|
|
|
|
|
resizing tempdb