This error prevents me from using SQL 2012 Express for storage on an external drive. This error does NOT occur with SQL Express 2008. I have been through several related google page finds related to this and not found a working solution.
Fsutil fsinfo ntfsinfo reports bytes per sector 512, per cluster 4096 per file record segment 1024 on both my internal c: drive and external drive. When using sql 08 I can create and use databases on either drive but 2012 sql shows this error on the
external drive (however it works when creating a database on the c:) drive.
Error Text:
Cannot use file 'S:\sqldata\Foo12.mdf', because it is on a volume with sector size 3072. SQL Server supports a maximum sector size of 4096 bytes. Move the file to a volume with a compatible sector size.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 5179)
Go to the complete details ...