November 25, 2009 at 6:34 am
iam in production , i ve a situation , because of low disk space temp db is full how can i increase the disk space or else can we shrink the templog file . is any other ways to resolve
replies are appreciated .
November 25, 2009 at 6:39 am
The very first thing you should do is add new file to Tempdb and location of file should be other disk drive.
You can try to shrink the tempdb files but it may take long time and also need disk space to perform the task.
In the worst case, simply restart the SQL Server service of your server which will rebuild the Tempdb from default size.
November 25, 2009 at 7:40 am
and if you were able to reduce the size it may be smart to try to figure out what made it grow cause it may happen again. if it's an abnormal size that is. we had some analysist writing bad sql queries and blowing up diskspace for example.
November 25, 2009 at 8:39 am
sometimes shrinking won't work due to open connections so we have to restart SQL and shrink right away before another connection starts hitting it
November 25, 2009 at 10:07 am
Atul is correct. First create the space for the tempdb. Then check for the reason it grown and then try shrink the files during offpeak hours.In the worst case you can restart the SQL Server service of your server.
November 25, 2009 at 12:35 pm
Heh... wait a minute, now... how big are the MDF and LDF files for TempDB? How much freespace do the other DB's have? Have you verified that TempDB is setup in the "Simple" recovery mode? Has someone put a lot of tables in the MODEL db which would also be built in TempDB on bootup? Are you doing correct backups on the other DB's if they're in the FULL or Bulk Logged modes of recovery so they don't just keep growing and growing?
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply