Results 1 to 9 of 9
  1. #1
    Join Date
    Jan 2004
    Location
    Bangalore India
    Posts
    2

    Unanswered: Unable to start the MS SQLServer Service

    Message logged in the SQL Server is

    Failed to report the current event. Operating
    system error = 31(A device attached to the system is not functioning.).

    The OS has been Shutdown and Restarted again but I am not able to start the SQL Server thereafter.

    Kindly Suggest

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Unable to start the MS SQLServer Service

    A time to rebuild your master db.

  3. #3
    Join Date
    Jan 2004
    Location
    Bangalore India
    Posts
    2

    Database Restoration

    I am unable to start the SQL Server and I do need to install the SQL Server again.

    1) If I install over it what happens to existing data is it overwritten or destroyed.

    2) Is it possible to restore the old database from Corresponding MDF and LDF files.

    Please help ASAP

    Thanks in advance.

  4. #4
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149

    Re: Database Restoration

    You need to install SQL Server, then restore your master from the latest backup - Providing your file sytem is cool then once you have the master up again then you should be OK.

    The master database holds a table called sysdatabases which has pointers to all the .MDF files and info to get the show back on the road.

    When was the last time you backed up your system databases?

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    You can attach the existing databases once you have sql server running. Do you have any backups ? Also, did you have any jobs/dts packages ?

  6. #6
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149
    you will need a backup of the MSDB to get any jobs/dts back

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The error message sounds like you have a disk that is not responding. Check to see if you can navigate with explorer to the master.mdf, mastlog.ldf, and the folder where the errorlog is supposed to go.

  8. #8
    Join Date
    Feb 2002
    Posts
    2,232
    Good point mcrowley - any time you have a scenario occur that exhibits abnormal behavior in sql server - run disk diagnostics. You can save yourself hours of work if you discover that the disk needs to be replaced.

  9. #9
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149
    Another good place to look is the event logs which can tell you useful O/S sytem errors relating to your problem at hand

    Cheers

Posting Permissions

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