SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Corruption in D:\$MFT. How may this progress? I don't think CHECKDB is useful here?


Corruption in D:\$MFT. How may this progress? I don't think CHECKDB is useful here?

Author
Message
tct_sql_admin
tct_sql_admin
Valued Member
Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)

Group: General Forum Members
Points: 61 Visits: 133
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
Jack Corbett
  Jack Corbett
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24144 Visits: 14905
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
enriquemallon
enriquemallon
SSC-Enthusiastic
SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)

Group: General Forum Members
Points: 137 Visits: 54
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.
JasonClark
JasonClark
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2343 Visits: 1061
Pls check your full database backup, restore databases to development or test server and run DBCC on development or test server to check for errors. If errors occurs while running DBCC it means there is corruption.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search