Microsoft KB Archive/926930

= Hard disk drive sector-size support boundaries in SQL Server 2005 =

Article ID: 926930

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Standard X64 Edition

-



INTRODUCTION
Microsoft SQL Server 2005 currently supports the following sector sizes that are equal to or less than 4 KB:
 * Physical sector sizes that evenly divide into 4 KB
 * Physical sector sizes that are smaller than the size of the original formatted sector size of the database, as long as the smaller sector size is evenly divisible into the originally formatted sector size
 * 512 KB
 * 1024 KB
 * 2048 KB
 * 4096 KB



MORE INFORMATION
SQL Server 2005 requires correct reporting of physical sector size to maintain data safety and avoid data loss. Avoidance of sector rewrites is a fundamental requirement of SQL Server. We do not support the read, write, and modify behavior that logical sector size reporting causes.

For more information about support for larger sector sizes, see the &quot;4-KB disk sector sizes&quot; section in the following white paper:

http://www.microsoft.com/technet/prodtechnol/sql/2005/iobasics.mspx

Additional query words: RWM

Keywords: kbhowto kbinfo KB926930

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.