sql-server – SQL Server支持最大扇区大小为4096字节

我正在尝试安装SQL Server 2012.它失败并显示消息 Cannot use file ‘D:\SQL\tempdb.mdf’,because it is on a volume with sector size 8192. SQL Server supports a maximum sector size of 4096 bytes. Move the file to a volume with a compatible se

我正在尝试安装SQL Server 2012.它失败并显示消息

Cannot use file ‘D:\SQL\tempdb.mdf’,because it is on a volume with
sector size 8192. SQL Server supports a maximum sector size of 4096
bytes. Move the file to a volume with a compatible sector size.

但是fsutil fsinfo ntfsinfo d:显示:

NTFS Volume Serial Number:       0x281643d216439fa4
NTFS Version:                    3.1
LFS Version:                     2.0
Number Sectors:                  0x00000000e8d29fff
Total Clusters:                  0x000000003a34a7ff
Free Clusters:                   0x000000002a37c684
Total Reserved:                  0x0000000000000000
Bytes Per Sector:                1024
Bytes Per Physical Sector:       4096
Bytes Per Cluster:               4096
Bytes Per FileRecord Segment:    1024
Clusters Per FileRecord Segment: 0
Mft Valid Data Length:           0x000000000a540000
Mft Start Lcn:                   0x00000000000c0000
Mft2 Start Lcn:                  0x0000000000000002
Mft Zone Start:                  0x00000000000ca540
Mft Zone End:                    0x00000000000cc820
RM Identifier:                   F3BAAB08-F2E7-11E2-804B-3C4A9279C348

D:驱动器是RAID 0驱动器,总容量为4 TB,由两个2 TB磁盘组成. RAID控制器是AMD RAID,其实用程序显示磁盘的扇区大小为1 KB:

为什么SQL Server安装程序认为磁盘扇区大小为8K,以及在此磁盘上安装SQL Server需要做些什么?

解决方法

AMD RAID几乎肯定是软件RAID,可能会向操作系统报告奇怪的事情.

在操作系统级别使用条带化,看看是否能解决您的问题.

仅be aware that if one drive fails you’ll lose all data on your 4TB volume.

我真的希望你只是用它来开发.

关于作者: dawei

【声明】:石家庄站长网内容转载自互联网,其相关言论仅代表作者个人观点绝非权威,不代表本站立场。如您发现内容存在版权问题,请提交相关链接至邮箱:bqsm@foxmail.com,我们将及时予以处理。

为您推荐