How to prevent from sql service got stuck? RRS feed

  • Question

  • Hello,

    I have installed SharePoint 2013(on premises) with sqlexpress and it's working successfully. After few months(around 6 months) getting "cannot complete this action please try again <nativehr>0x80004005</nativehr>" issues.

    I have checked and found that the SQL server services got stuck on starting mode. I have restarted service and site is start working now.

    How can we prevent such type of thing in future?

    Lovkesh Patel

    • Edited by LovkeshPatel Tuesday, April 19, 2016 7:12 AM Added image
    Tuesday, April 19, 2016 7:10 AM


  • Don't re-start SQL unless you need to and only do so when there's a human in the loop to deal with these issues.

    Without more detail on why SQL failed to start we can't help.

    • Proposed as answer by Victoria Xia Thursday, April 28, 2016 11:34 AM
    • Marked as answer by Victoria Xia Tuesday, May 3, 2016 12:28 PM
    Tuesday, April 19, 2016 9:38 AM