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 |
|
Prabha
Starting Member
1 Post |
 Posted - 2005-01-19 : 06:28:27
|
| HI all,I am getting the following error and I have been trying to find the solutions since 3 days. But I am unable to find the solution. I am getting the following error while I am executing my stored procedure. The error is as follows..........The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.. I have tried a lot with the tempdb properties. but I could not find the solution. Please let me the solution.Thanks in Advance |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2005-01-19 : 07:08:20
|
| in EM right click on tempdb; Properties; tab Transaction Log;what is the "Maximum file size" option there? |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-01-19 : 07:17:27
|
| have you tried backing up the tempdb log file?--------------------keeping it simple... |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-01-20 : 02:27:39
|
| It sounds like the transaction within your procedure is filling the log file and the log is not set to expand. You can either increase the size to be "big enough" or allow the log file to auto-grow.Also, what type of recovery model does the tempdb have?HTH=================================================================Scriptures, n. The sacred books of our holy religion, as distinguished from the false and profane writings on which all other faiths are based.-Ambrose Bierce, writer (1842-1914) [The Devil's Dictionary] |
|
|
|
sreemace
Starting Member
9 Posts |
Posted - 2005-01-20 : 02:36:46
|
| To view the usage of files(logspace) use the command below......dbcc sqlperf(logspace) When the transaction log becomes full, use the command below to free space in the transaction log file...backup transaction database_name with no_log Thanks & Regards,Sreejith G |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-01-20 : 04:53:04
|
| What does status show in executing dbcc sqlperf(logspace)? Status shows 0 for all the databasesMadhivanan |
|
|
|
|
|
|
The log file for database 'tempdb' is full