Microsoft KB Archive/926930

From BetaArchive Wiki
Knowledge Base


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 "4-KB disk sector sizes" section in the following white paper:


Additional query words: RWM

Keywords: kbhowto kbinfo KB926930