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 |
|
dairec
Starting Member
16 Posts |
 Posted - 2006-06-07 : 09:43:00
|
| Hi there.I have a problem with a task in my SQL Server 2000 DTS Package.The problematic task is a data-driven query that performs an update of a set of records in my “Risk� database. The task appears to run successfully but no update takes place. In addition the exception log for the task returns the error message The log file for database 'Risk' is full. Back up the transaction log for the database to free up some log space.I have shrunk and backup/truncated the Risk log file which now stands at 11MB and it is set to grow at 10% to an unlimited size. I then backed up the database but this made no difference either. I tried changing the grow size to 50% but it also made no difference. There is 4.5GB free on the drive where the log file resides. Also the recovery mode for the database is set to Full Recovery.Any suggestions would be great.Dáire |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-07 : 21:37:44
|
| when you run the dts, observe if the 4 gb disk space is consumed or not, this maybe your problem...HTH--------------------keeping it simple... |
 |
|
|
|
|
|
Strange “Full Log File†Message Question