The transaction for database 'xxxx' is full.

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

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

fews already reply you at http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_26483168.html

please see if it can help you out.
0
 
joriszwaenepoelCommented:
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.
0
 
arunbhattAuthor Commented:
Hi,
  Yes I meant "transaction log". Thanks for the response.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
WaynepiCommented:
depending if your database recovery module was set to full.
Backup you db and run the following : Backup (yourdatabase) log with truncate__only
0
 
SwindleCommented:
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: http://msdn.microsoft.com/en-us/library/ms189272.aspx

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.
0
 
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.
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.