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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 tempdb full

Author  Topic 

steel
Posting Yak Master

107 Posts

Posted - 2008-09-26 : 09:06:57
hello all,


Its really urgent.....

I am getting an error that the transaction log for tempdb is full backup the transaction log.ispite of the fact that there is enough space in the corresponding drive.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-09-26 : 09:08:53
Log space and disk space are not comparable.

See log space as how much you have filled your suitcase when going on a vacation.
See disk space as how big the suitcase is.


When your wife fills her suitcase going on a vacation, you will get a "log file full" error message.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-26 : 09:13:50
Did you enable Autogrow option on TEMPDB? What recovery model is you TempDB?
Go to Top of Page
   

- Advertisement -