We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Disk Full Error - transaction rolled back

rickwinterkorn
on
Medium Priority
281 Views
Last Modified: 2008-02-01
I verified that there was plenty of memory after getting this error.  It occured when trying to connect ISQL to the database.  Any idea what I should check next?
Comment
Watch Question

Author

Commented:
Edited text of question

Commented:
Could you give some specs on the system, and the exact error message.

Commented:
Get back to me on the following things.  What does sp_who output give?  if it is under unix what does ps -ef gives.  Also sp_lock shows what types of lock.  lastly give me information on what version (Excat) of dataserver and ISQL version

Commented:
Are you getting this message from a Client connected to a database server?

If yes, the system partition on the server where the database server is installed is very low on space.

If no, (the case you are using a local database) the partition where the database engine and/or database file are on is very low on space.  

I had this problem once and I clear up some unused files to do some space on the hard drive and it was ok after.

Author

Commented:
Kaos87..thanks for the info, I cleared some space in the partition and it works fine now.  
you should reject the answer from vsriks
Koas87 post an answer if rickwinterkorn does
Just a thought like that....

Author

Commented:
Koas87 - Post an answer..or just something ...so that I can accept it as answer and give you credit..Thanks again
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.