Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2004
    Location
    Rhode Island
    Posts
    69

    Unanswered: SQL Server is down

    Hello,
    My SQL Server is down. I could not access it from any client application or Enterprise manager.

    When I looked the SQL Server Service Manager it is running.

    When I connect from Query Analyzer it throws network error.

    Can any one help me how to troubleshoot it. I greatly appreciate it

    thanks

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    When I looked the SQL Server Service Manager it is running
    Effectively that means your SQL Server is running ... Unless M$ screwed something up somewhere

    Are you not able to connect from the client machine or are you on the server itself ???
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    SQL Server Service Manager can sometimes give poor results, since it is not refreshed too automatically. Hover the mouse pointer over it for a few seconds to see if it changes. A better way to check if the server is running is to check in services to see if it is marked as running.

  4. #4
    Join Date
    Feb 2004
    Location
    Rhode Island
    Posts
    69

    Re: SQL Server is down

    Thanks for the reply.

    1. From Enterprise Manager running on the server itself could not expand that server.

    2. I moved cursor over the Server Manager at the system tray. It says running.

    3. Then I stopped the service to restart it again. Guess what
    for the 15 minutes it is trying to stop the service. (says stopping)

    4. Looked at the windows event error log. I donot see any errors related to sql server

    Any suggestions.

    thanks

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Try opening the latest errorlog file in the SQL Server log directory. You should be able to view it in notepad. Also, check in task manager for SQLSERVR.exe, to see if SQL Server has already stopped, but has not told the service manager. Also, anything in the system event log? How big are the databases you are dealing with here?

  6. #6
    Join Date
    Feb 2004
    Location
    Rhode Island
    Posts
    69
    Can you please tell me the Log file name?

    The datbase size is something around 300MB. 4 of them in that server

    I viewed the System event log. I did not see any errors related to SQL Server

    Originally posted by MCrowley
    Try opening the latest errorlog file in the SQL Server log directory. You should be able to view it in notepad. Also, anything in the system event log? How big are the databases you are dealing with here?

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Do a search on the system for files called errorlog. You should see errorlog (the latest one) and several others called errorlog.1, errorlog.2... They should all be in the same directory.

  8. #8
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    ERRORLOG is the first one to lookup and also on the server from control panel --> services check whether these 2 services are started or not.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •