The transaction for database 'xxxx' is full.

  How to fix: 'The transaction for database 'xxxxx' is full' when deleting data?

Who is Participating?
JoeNuvoConnect With a Mentor Commented:
you post same question twice.

fews already reply you at

please see if it can help you out.
Maybe you mean the "transaction log"?  In that case, making a backup of the database could help.  
If you have that often, then you can change the size of the transaction log, or make it grow automatically.
arunbhattAuthor Commented:
  Yes I meant "transaction log". Thanks for the response.
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

depending if your database recovery module was set to full.
Backup you db and run the following : Backup (yourdatabase) log with truncate__only
If the database is set to simple recovery model, you need more disk space to perform the delete and there's not really another answer.  Try freeing up space or adding another log file to the database on another drive where there is available space.

How to check the recovery model:

If the database is set to full recovery model, then:

Set the database to simple recovery model
Perform your delete
Set it back to simple recovery model.
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
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.