Sector size error while creating database in SQL Server 2008 on Windows 2008R2
Posted on 2011-09-19
We're facing an odd issue on a couple of our MS SQL Server machines. They are running SQL Server 2008 (not R2), and Windows 2008R2.
We're using a query to create a database, using H: for the data partition and E: for the transaction logs. When we run the query, we get the following error:
Msg 5177, Level 16, State 1, Line 2
An unexpected error occurred while checking the sector size for file 'E:\SQLData\MonitorDB_1.ldf'. Move the file to a local NTFS volume, where the sector size can be retrieved. Check the SQL Server error log for more information.
We tried putting the transaction logs on G: instead (there are a number of partitions on this machine), and G: works fine. Only the E: partition is having the problem. I checked the filesystem permissions, and E: and G: are identical. Both the user who is running the queries and the local SYSTEM account have full NTFS privs to the entire partitions. They are both empty, freshly formatted partitions (no files), and both are the same size. They both use a 64k cluster size in NTFS. The user running the queries can successfully create and delete folders and files manually on the E: partition.
I'm fresh out of ideas on this one. My next step might be to delete and recreate the E: partition entirely, but I'd really like to know what is causing this.