kb982018 and Bytes Per Physical Sector

[AWS]

As an intro,  I had a problem not being able to restore/create a database on a external HDD, SQL server complaining it does not support sectors with size 3072.

 

After some digging I understood that this could be due to SQL server not being able to read bytes per sector, and indeed "fsutil fsinfo ntfsinfo h:" reports "Bytes Per Physical Sector :       <Not Supported>"

 

 

I had this update installed so I removed it and that added back, with no success.

Note that it took some struggle to do this, as after installing/removing it Windows got "stuck" on "updating, no not shutdown" message for like 10-15 minutes so I manually turned it off and back on. And eventually remove/install the plugin one more time

as it was not visible as installed/removed.

 

Any way, the questions: 

1. should the update fix the fsutil for the external drive?

2. how can I check if files were updates as under http://support.microsoft.com/kb/982018 each file appears 4 times, which version is the "correct" one and under which folder? (see remove/install issues above) 

 

OS: win 7 enterprise

 

"fsutil fsinfo ntfsinfo h:" output

 

NTFS Volume Serial Number :       0x88465396465383ba

Version :                         3.1

Number Sectors :                  0x000000000c80b1c0

Total Clusters :                  0x0000000001901638

Free Clusters  :                  0x0000000000130657

Total Reserved :                  0x00000000000005d0

Bytes Per Sector  :               512

Bytes Per Physical Sector :       512

Bytes Per Cluster :               4096

Bytes Per FileRecord Segment    : 1024

Clusters Per FileRecord Segment : 0

Mft Valid Data Length :           0x000000000dc00000

Mft Start Lcn  :                  0x0000000000079e05

Mft2 Start Lcn :                  0x0000000000007477

Mft Zone Start :                  0x000000000121c3a0

Mft Zone End   :                  0x0000000001228bc0

 

 

View this thread