Does Anyone Know What This Means?
Microsoft OLE DB Provider for SQL Server error ‘80040e14′
The transaction log for database ‘CITI_PRODUCTION’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
/Default.asp, line 83
Tags: Anyone, Does, Know, Means, This, What
This entry was posted
on Thursday, December 24th, 2009 at 12:05 am and is filed under sys files.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
make sure you have drive space left and clear out your sql transaction log. I believe it is usually in c:program filessql server90…
As the others state, the error message is pretty self-explanatory. Possible fixes:
1) Increase size of log file – quickest safe method but hardware dependent)
2) Archive old entries in log file and compress – hardest method to implement but once done easy to do as needed (and safest)
3) Delete log file entries (quickest, but most dangerous since there’s no going back)
Well.. did you *read* it? It tels you the transaction log is full.
Step 1. Check if the disk is full. If so, make it un-full.
Step 2. Look at the column in sys.databases that it tells you to look at, and see if that tells you anything.
You can shrink the log file
OR
use “simple recovery model” for the log will not grow in future.