Post reply

Need some help. I may have crashed the instance.

  • August 23, 2016 at 10:43 am

    #320790

    So I am working on testing the script I wrote since there were couple of databases we had in "suspect" mode. So I ended up writing a script which executes every 15 minutes on all servers and looks for any databases that are in "suspect" mode. Just to test this, I am following this

    http://www.sqlskills.com/blogs/paul/creating-detaching-re-attaching-and-fixing-a-suspect-database/. So now I am not able to login at all and getting the error "Network related or instance specified error. This is a test environment and has about 5 databases. When I open up configuration manager, I don't see the service running. Can I get some help on what to do?

  • August 23, 2016 at 10:55 am

    #1896973

    Start the service?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 23, 2016 at 10:57 am

    #1896976

    Thanks! Didn't think about that. Its running now.

  • August 23, 2016 at 11:43 am

    #1896989

    You can check the previous error log to see why it stopped

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 24, 2016 at 5:21 am

    #1897139

    GilaMonster (8/23/2016)

    You can check the previous error log to see why it stopped

    And verify it's set to start Automatically instead of Manually.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 5 posts - 1 through 4 (of 4 total)

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