• what if system databases go suspect mode due to corruption during transaction rollback or during crash recovery.that time will the sql server will be alive?

    Suspect mode requires that SQL encounters corruption during a transaction rollback or during crash recovery. Typically, because the system databases (other than MSDB) aren't changed much, there aren't many rollbacks and corruption would much more likely be encountered during crash recovery on startup.