Skip to main content
M
matthisco
Inspiring
February 2, 2009
Question

SQL Server 2005 Error

  • February 2, 2009
  • 2 replies
  • 535 views
hI Folsk,

I get this error when I try and modify a table.

It says the log for tempdb is not available. Resolve any errors and restart the Db.

I'm not sure how to restart the Db, I dont want to lose any data.

Can anyone tell me how to solve this?

I just need to modify a column.

Thanks



This topic has been closed for replies.

2 replies

M
matthiscoAuthor
Inspiring
February 3, 2009
That seems to of done the trick!

Thanks very much!
A
Anonymous
February 3, 2009
I'm not quite sure why sql would all of a sudden not be able to find the log file for the temp db.

I would just restart the sql service. Start->Run->type services.msc-> OK.

This brings up the windows service console. Scroll down to find the sql server service, right click and hit restart. It will ask you if you also want to restart sql server agent, this is OK. SQL server is usually pretty good at recovering data when it is restarted in this fashion, so I wouldn't worry about data loss.

If after the restart things with the Temp DB are still not good I would look for other solutions. Is the disk full? Have any permissions changed? Have any service packs been applied recently?
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices