Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Disk Full Error - transaction rolled back

Posted on 1998-06-24
8
Medium Priority
?
264 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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 

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
 

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 200 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month11 days, 2 hours left to enroll

886 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