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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-04-03 : 17:15:23
|
| HiI am getting this error"The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space."I have truncated logfile also.can the problem be coz of disk space on c drive.it is only 400 mband there are 35 databases.Regards |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-03 : 17:36:34
|
| Yes that could be the problem. Tempdb shouldn't be on the C drive in the first place though. Tempdb needs to have enough storage space to support whatever queries will hit it. I usually have a few gigabytes of free space on my tempdb drive, just in case.Tara Kizeraka tduggan |
 |
|
|
|
|
|
Transaction log backup