Hi Guys.. thanks for all your input.

Are there ANY tools out there that will Repair a SQL corrupt file.
A DBA will not be on call !!!

Regards,
Gerard



>>>Hi.
>>>I am about to install a Web based app using Sql Server Express as
>>> the backend.
>>>
>>>I am a little nervous about this as I dont have any tools in case the Tables crash or become corrupt.
>>>
>>>With VFP. we have an arsenal of 'stuff' that can uncorrupt tables, fix indexes etc.
>>>
>>>I'm just wondering what utilities there are out there if I end up one daya with a corrupt Sql DServer database.
>>>
>>>Any help appreciated.
>>>
>>>regards,
>>>
>>>Gerard
>>
>>Gerard,
>>
>>In 6 years I have not seen SQL Server 'crash'. I have seen disk controllers and motherboards fail, but never the software.
>>
>>For fixing databases, there are built-in sql commands for checking the consistiency and repairing a database. But only an experienced DBA should use them. Your best bet is a good maintenance plan.
>
>Keith,
>In the last year I was able to crash SQL2000 developer editon server and I couldn't restore it no matter what I did (not HW fault BTW). Yes I'm not an MSSQL DBA and probably a DBA would know a way to recover w/o backups. In case of Express it's likely there wouldn't be a DBA around.
>Luckily all I had in that was test databases (and actually it was some aggressive test that broke it:).
>Cetin