Post reply

dbcc repair_rebuild

  • December 11, 2018 at 9:00 pm

    #416549

    I ran the above dbcc command and using sp_who2 to check status, its showing as suspended state
    Please let me know if I can kill the process and restart it

    Thanks

  • December 12, 2018 at 1:06 am

    #2016066

    atulyan.aries - Tuesday, December 11, 2018 9:00 PM

    I ran the above dbcc command and using sp_who2 to check status, its showing as suspended state
    Please let me know if I can kill the process and restart it

    Thanks

    Is there any corruption with the database? The suspended sate can be many reason, when the session lock and hold for the activity.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply