I have a Windows Server 2003 server that is being mainly used for some reporting done in SQL Server.
Recently Windows has started complaining about being corrupted, we are getting an NTFS error 55:
The file system structure on the disk is corrupt and unusable. Please run the chkdsk utility on the volume \Device\HarddiskVolume1.
The server is RAID 5 and I did have a disk die however the RAID never went degraded since I have a hotspare. I replaced the hot spare and I'm still having problems.
When I run chkdsk I get tons of messages.. some are:
Deleting corrupted attribute record (128, "") from file record segment 194746
Those go on for a while. Then it deletes some orphan files. Then it does
Correcting error in index $I30 for file 132426
And that goes on for a while. Then I get tons of
Recovering orphaned file RE1AB6~1.LOG into directory file 534959
I have seen a lot of errors relating to the SQL Server reporting services.
What are my options at this point? I would prefer to fix the issue instead of building a new server but I don't know if I can at this point.
Best Answer
No one can really tell you what to do without more information, specifically the SQL Server errors. Personally I'd just copy the SQL log/data files off your RAID, restore from backup, and then restore the current SQL log/data files.