>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only