• When a drive craps out on you, there's always a possibility a database can become corrupt. If you are able to hot-swap the drive successfully, there's nothing needed to be done from the database side.

    I am no expert on corruption but the experts here would ask you to run this script and post the results for each database which you think might be affected.

    DBCC CHECKDB('databaseName') WITH NO_INFOMSGS,ALL_ERRORMSGS

    Whatever you do, do NOT run the checkdb command with any repair options! (not yet at least. not until an expert tells you to.)

    They will also ask if you have good backups to restore to in the event there is no recovering from the disk failure.

    Once done, they will be able to help you.

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.