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 : &ltNot Supported&gt"

 

 

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