Hi @devendra ,
> Msg 0, Sev 0, State 1: Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000]
>Msg 596, Sev 21, State 1: Cannot continue the execution because the session is in the kill state.
Please refresh your SQL server instance and check the database state again.
> DBCC CHECKDB (MyDB) terminated abnormally due to error state 6. Elapsed time: 1 hours 1 minutes 38 seconds.
Please check if this blog DBCC CHECKDB … Terminated Abnormally Due to Error State 6. could help you. As others mentioned, suggest you check your error log or agent log to find more related error message.
Best regards,
Cathy
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.