Administrators AWS Posted March 22, 2013 Administrators Posted March 22, 2013 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
Recommended Posts