May 5, 2014 at 10:41 am
Hello
I have a server that is reporting NTFS errors; one of the error messages implicates d:\$MFT as being possibly corrupt. My SQL data files reside on this drive.
The Master File Table holds information about all files on the disk, so I imagine if the corruption was to occur SQL may not be able to read data from one of the MDFs or NDFs?
I imagine CHECKDB will not be a relevant consistency check, and the only way to resolve this error would be a chkdsk /r?
Any help would be appreciated. We haven't had any corruption reports in the SQL error log yet. I imagine it could get serious depending on what parts of the MFT are corrupted (as previously stated it could affect SQL's ability to read MDFs or NDFs)?
Thanks
May 5, 2014 at 11:19 am
Since Windows is presenting these errors I'd look to get my SQL Files off that drive and then run CHECKDB against all the databases that were there. I'd also do test restores of the most recent backups of those databases and run CHECKDB against them to make sure my latest backups are of good databases.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 3, 2014 at 5:33 am
hi
The possible reason for NTFS error is corruption hence you need to repair Windows OS and after this you can restore it from updated backup. If you don't have a backup then you must go with external tool.
September 4, 2014 at 5:16 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply