• Hi, It worked well but as I execute command to bring the database online after modifying the .mdf file. SQL Server throws an error:

    Msg 926, Level 14, State 1, Line 1

    Database 'Corrupt2K8' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.

    Msg 5069, Level 16, State 1, Line 1

    ALTER DATABASE statement failed.

    Msg 5125, Level 24, State 2, Line 1

    File 'E:\SQL DATA\Corrupt2K8.mdf' appears to have been truncated by the operating system. Expected size is 524288 KB but actual size is 524280 KB.

    Msg 3414, Level 21, State 1, Line 1

    An error occurred during recovery, preventing the database 'Corrupt2K8' (database ID 10) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.