question

Mias avatar image
Mias asked

ole 800 errors, please help

Hi. Thank you for taking the time. I have problems with a specific sql server, I get ole 800 range errors. I am an installation and support technician, low to perhaps mid level sql skill. Attached is an example of a random error we get. This was sent to me today by the server administrator. I support a Delphi front end app, with sql back end. Hardware Description: Linux Host machine, with 20 GB ram available. On top of that, virtually, sits the Windows Server 2008, that carries the sql installation. The dbase is 60 GB in size. (I believe the hardware is the issue, if you want to know more, let me know. 130 users log on!) Problem description: OLE 800 range errors, all over. I resolve them by increasing the size under files in the management studio. It doesn't always work. Sometimes restarting the sql server service helps.
storagevirtualizationhardwareram
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

You mentioned that you intended to attach an error example. Can you do that (or paste in the error text)?
0 Likes 0 ·
Hi, thank you. here is the error massage attached. In the mean time we gave found a lot of bad sectors in the database.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
You will have to run DBCC CHECKDB() to identify where you have problems. It's possible that they're only in non-clustered indexes which can be easily dropped and recreated. Otherwise, you may be facing fundamental corruption issues. The best solution there is to go to a good backup of the database. You may be seeing disk or I/O issues, so you should also run fundamental system checks to see where the problem may be occurring.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank You. Yes, we have now hired an SQL specialist, at a fat hourly rate, to come in here and have a look at this. His initial findings is in line with what you say, Thank You.
0 Likes 0 ·
Mias avatar image
Mias answered
Here is the error message. Thank You. ![alt text][1] [1]: /storage/temp/1313-20140126_160736.jpg

20140126_160736.jpg (25.2 KiB)
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

You have corruption, most likely as you mentioned due to a bad hard drive. Do you have a recent valid backup of the database?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.