On Windows 11, some PCs have SSDs (and possibly hard drives) that are formatted with sector sizes that are not compatible with Microsoft SQL. We have found a registry addition that will fix this problem.
Error when attempting to start SQL Windows service:
"originally formatted with sector size 4096 and is now on a volume with sector size 32768"
Steps to Fix (Registry)
- Uninstall all SQL
- Uninstall EBM
- registry fix
https://learn.microsoft.com/en-us/troubleshoot/sql/ database-engine/database-file- operations/troubleshoot-os- 4kb-disk-sector-size - Reboot
- Rename C:\Program Files\Microsoft SQL Server\MSSQL11.
VISION2012SP1EBM to
C:\Program Files\Microsoft SQL Server\MSSQL11.VISION2012SP1ebm_sector_size_ mismatch_error
(to ensure the newly installed instance does not share any previously installed files) - Reinstalled EBM
Additional Information
- https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/database-file-operations/troubleshoot-os-4kb-disk-sector-size
- https://support.microsoft.com/en-us/topic/kb3009974-fix-slow-synchronization-when-disks-have-different-sector-sizes-for-primary-and-secondary-replica-log-files-in-sql-server-ag-and-logshipping-environments-ed181bf3-ce80-b6d0-f268-34135711043c
Comments
0 comments
Article is closed for comments.