var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
Re: Unable to start the MS SQLServer Service
A time to rebuild your master db.
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.
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?
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 ?
you will need a backup of the MSDB to get any jobs/dts back
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.
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.
Another good place to look is the event logs which can tell you useful O/S sytem errors relating to your problem at hand