asked on

Repair Corrupt Database?

one of my SQL database corrupt. and i dont have any backup ......i got the bigest prob. i tryed to repair will all the 'DBCC' command but none of those works.. i tried 'dbcc checkdb', 'dbcc CHECKALLOC', 'DBCC CHECKTABLE' but none of this find any problem. is there any extra tools or other command to repair MSQL 7.0 Database. please helpppppp please....

In access i always Jet4 repair database command but what should i use in SQL?

....................Shurid

JohnaWatts

What error message is SQL giving you?

substand

i think you are pretty much screwed. but there are people to call. for example:

http://www.arc24.com/english/preise/preise.html

that gives the prices. its not cheap for recovery though. like 1000+ dollars. the good news is, you don't pay unless it works.

ASKER CERTIFIED SOLUTION

substand

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

shurid

ASKER

sorry but i am in Bangladesh In Asia region. so it would be much more costly then that but i cant spent that much. i was looking for any tools which re-build all the data into new table or repair them.......thankx anyway....shurid

substand

there may be tools. what is the exact message you are getting?

have you tried looking in the microsoft knowledgebase? I did a search, and there were too many articles, some that specified bugs. with the error message, you may be able to narrow it down to a bug and download a patch, or find some tools.

shurid

ASKER

i am not getting any message from sql cos its not responding ..... what i meant by tools is that some time u will get some extra repair tools for zip repair or similar. i wanna know is there any prog which can repair sql db?

shurid

ASKER

thankx substand ...i am sorry cos i am thanking u after a long time. but that worked & i forget to give u the points but now i am giving it ........thankx u r the best