We have had an issue with our RMS_Headquarters(front end application to access database) database running on SQL Express 2005.
After checking all the event log on server, I came across few errors related to hard disk and sqlserver.
disk error snapshot
sqlexpress error
I have executed two commands as follows to find out any error in disk or on sql database.
chkdsk : System found bad sectors on hard disk I ran this code without /f to just get the information.
DBCC CHECKDB with ALL_ERRORMSGS, NO_INFOMSGS and the outcome was as below.
I ran chkdsk /f to resolve the disk error. This command helped to get hq database up and running (application was working fin ...
Go to the complete details ...