Link to home
Start Free TrialLog in
Avatar of desaiviveks
desaiviveksFlag for India

asked on

Database Engine Error: Index does not exist.

Hi
I am facing an issue while running a dBase applicaton it throws following error:
Database Engine Error:  Index does not exist.
The reason what I believe is that I have moved all the database to one single server where we have hosted both the database that exist on 2005 and 2000.
Kindly please help me to resolve this issue.

Thanks in advance
Avatar of desaiviveks
desaiviveks
Flag of India image

ASKER

Require urgent attention
Avatar of Pavel Celba
If your application is really dBase then it seems you did not move all necessary files. Databases have DBF extension, indexes should have MDX, NDX, or eventually IDX and CDX if you are using FoxPro.

If you are using SQL Server then indexes are inside the database and your problem is somewhere else. Yo should check database integrity by DBCC CHACKDB command.

So, you should say what database engine are you using and the check if all files were moved properly.
The SQL command to check the database integrity is

DBCC CHECKDB (DatabaseName)

You should also post more info about the error. I don't believe it is so short without details.
04/22/2010 05:47:21.07
R:\RLEB\RLEB.exe
R:\RLEB\zcontrol.cc
ZTEXT::INIT
1299
239
Database Engine Error:  Index does not exist.
--
Here is the error message
Please see the result after running the
DBCC CHECKDB (DatabaseName)

CHECKDB found 0 allocation errors and 0 consistency errors in database <DatabaseName>
ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Appreciate your quick reply. Let me check out with my Vendor.
Got the solution with the clue provided.