Solved

Disk Full Error - transaction rolled back

Posted on 1998-06-24
8
253 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?
0
Comment
Question by:rickwinterkorn
8 Comments
 

Author Comment

by:rickwinterkorn
ID: 1098074
Edited text of question
0
 

Expert Comment

by:gilmer
ID: 1098075
Could you give some specs on the system, and the exact error message.
0
 

Expert Comment

by:vsriks
ID: 1098076
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

0
 

Expert Comment

by:kaos87
ID: 1098077
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.

0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:rickwinterkorn
ID: 1098078
Kaos87..thanks for the info, I cleared some space in the partition and it works fine now.  
0
 
LVL 1

Expert Comment

by:spacebrain
ID: 1098079
you should reject the answer from vsriks
Koas87 post an answer if rickwinterkorn does
Just a thought like that....
0
 

Author Comment

by:rickwinterkorn
ID: 1098080
Koas87 - Post an answer..or just something ...so that I can accept it as answer and give you credit..Thanks again
0
 

Accepted Solution

by:
kaos87 earned 50 total points
ID: 1098081
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.

0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Help with SQL query 3 2,184
Backing up Sybase database Server using Veeam 3 1,072
SQL Left join on same table 4 291
Temporary tables in Oracle 9 130
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
What is Backup? Backup software creates one or more copies of the data on your digital devices in case your original data is lost or damaged. Different backup solutions protect different kinds of data and different combinations of devices. For e…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now