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 |
|
tocroi72
Yak Posting Veteran
89 Posts |
 Posted - 2006-07-11 : 09:51:10
|
| Hi,I am running a stored procedure and i receive an error message below"The log file for database is full. Back up the transaction log for the database to free up some log space."my database is small and i have full backup every night - recovery option is set to "Simple" - - i don't understand why the log file is big? - any idea what should i do?- i already shrink the database and rerun the sp and still get the error.Thanks |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-07-11 : 10:26:39
|
| Sounds like whatever your SP is doing is generating one very large transactional unit of work that is expanding the log file to more space than is available to it, either by hard (disk space) or soft (sql server limited space) limits. What does the proc do?-------Moo. :) |
 |
|
|
|
|
|
Log file