Does anyone know what this means?

Question

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

Answer 1

make sure you have drive space left and clear out your sql transaction log. I believe it is usually in c:\program files\sql server\90\...

Answer 2

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)

Answer 3

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.

Answer 4

You can shrink the log file

OR

use "simple recovery model" for the log will not grow in future.