November 13, 2008 at 7:25 am
Hi all, just started a new job where my resposibilities besides being a Business-analist, are also all the IT stuff.
Now the problem... suddenly today the c-drive of one of our servers is running low on hd-space.
Because of the fact that the tempdata.mdf file has grown to a stunning 56gb.
What can I do?
Cheers from Amsterdam,
Martijn
November 13, 2008 at 7:34 am
instant solution, if you can try to restart SQL server, and then find the cause of it. 🙂
November 13, 2008 at 8:09 am
If it is the tempdb.mdf then restarting will reset the size to the original creation size which is likely a couple mb. However you will want to identify the cause of the growth. Long running or open transactions could be a cause.
If the file is for a user database (since your reported name is slightly off for the tempdb in 2005) then you can look at shrinking the file if there is a lot of unused space. Some will not recommend this, but I feel you can do it if required and your prepared to rebuild stats, indexes, etc as well as allow for some slower performance while you rebuild and growth occurs.
You can also look to moving the file to an alternate drive. You can alter the path using the ALTER DATABASE or sp_detachdb/attach/db commands. This will allow you to move it to a drive with more space.
November 14, 2008 at 1:12 am
that did the trick! Thanks... I will monitor that file for the next few days, and see what happens.
Thanks again!
Martijn
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply