Microsoft SQL 7 42000 consistency error

I have read other responses that say make sure no one is in the database and make sure you have a good backup but my case is different. This server runs a legacy application and it caught a virus but the virus never got to the data files. A backup was made and tested on another server and it worked fine. The original server was rebuilt and an attempt was made to restore the backup and the error 42000 consistency appeared. The same backup was put on another server and it worked however on a fourth server the same consistency error appeared. Each server tested was a new sql server install. A new backup from one of the test servers that worked was made and put on the server that is needed and the error still occurs,. I have even uninstalled and installed sql again and the error still occurs...

Any suggestions because the original server has been rebuilt and  this is my only backup...

Thanks
rf
ivron001Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

elimesikaCommented:
hi

run DBCC CHECKDB
see what the problem is, if it is in index,PK or FK simply drop and re-create it
0
ivron001Author Commented:
dbcc checkdb reported the following...

CHECKDB found 0 allocation errors and 0 consistency errors in database

What is strange about this is that all sql installations came from the same install disk yet two work and two does not work. The same backup file was used by all installs. I am pulling my hair out over this one. Any chance you have another suggestion.

rf
0
elimesikaCommented:
Is there any change in machine OS Service pack ?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

ivron001Author Commented:
That was a good suggestion but it did not work. To be safe I uninstalled SQL then loaded the updates including the service pack to match the systems that work. I then loaded SQL again and tried to install and got the same error message. I also tried backing up the database again and restoring that backup to the new server and still get the same message. I have been doing this for years and this is the first time I have gotten this error.
0
elimesikaCommented:
Seems like the virus may spread to other computers
Do you mind downloading the latest version of Sbybot and configure it to run once on reboot.
Try again when the machine is up after Spybot completes

http://www.safer-networking.org/en/download/index.html
0
ivron001Author Commented:
I used Enterprise to gain access to both servers at once. I tried to restore to the SQL server that did not work using Enterprise on the server that does work and got the same message. I then used the same Enterprise and the same backup on the server that did work and it restored properly. I got tired of screwing with it and used the export to move all tables to the problem SQL server and it worked. I am now going to try it on the live server and hopefully I will get the same results. I will also create a new backup and test restore on all servers. Will let you know the results.

Thanks for your suggestions
0
ivron001Author Commented:
Just in case anyone comes across this issue the export and import feature worked in all scenarios. Once the data was imported into the destination server I was able to make a valid backup that restored for all servers. I was never able to determine what the exact problem was for the original backup file.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ivron001Author Commented:
the solutions given were great suggestions however they did not solve my problem. I solved it myself but I was grateful for the time and effort given by those that responded.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.