The transaction log for database 'xxx' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

I have a database xxx, recovery model set to full.  A full backup of the database is done daily, the transaction logs are backed up hourly.

I keep getting the above error message when I try to do a fairly lengthy insert.  I've backed up the database, backed up the transaction log, grown the transaction log, to no available.

The transaction log for database 'xxx' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

Currently, log_reuse_wait=0
log_reuse_wait_desc=Nothing

Any suggestions would be appreciated.
PetEdgeAsked:
Who is Participating?
 
Scott PletcherConnect With a Mentor Senior DBACommented:
Do a:
DBCC OPENTRAN (databasename)

[Or USE databasename DBCC OPENTRAN]

and see if that reports anything.

If not, check your disk space.  The disk may be full where the log needs to grow. [Temporarily it looks like the log will need to grow even though in theory space should be available on the existing log.]


0
 
Ephraim WangoyaConnect With a Mentor Commented:
Looks like you have run out of disk space
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.