Microsoft KB Archive/281220

= PRB: Error Message Occurs When You Create or Expand a Database on a FAT32 Partition =

Article ID: 281220

Article Last Modified on 8/16/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q281220



SYMPTOMS
In SQL Server 7.0 on a Microsoft Windows 2000-based computer, the creation or expansion of a database data file greater than 4 GB on a FAT32 partition may result in the following error message, even when there is more than the required amount of disk space available:

Operating system error 112(There is not enough space on the disk.) encountered.



CAUSE
The FAT32 file system has a maximum allowable file size of 4 GB.



WORKAROUND
To work around this problem, create the database on multiple files, each smaller than 4 GB, or use an NTFS partition.



MORE INFORMATION
In SQL Server 7.0, if a database larger than 4 GB is restored to a single data file on a FAT32 partition, a failed assertion may occur, followed by error 3624 and operating system error 112. For example:

Short Stack Dump

0x77f97ac6 Module(ntdll+17ac6) (NtGetContextThread+b) 0x00778999 Module(sqlservr+378999) (utassert_fail+1a0) 0x0070e6cd Module(sqlservr+30e6cd) (BackupFileDesc::CreateDevice+229) 0x0070f7ce Module(sqlservr+30f7ce) (BackupFileList::CreateDevices+94) 0x006f7fb1 Module(sqlservr+2f7fb1) (BackupOperation::CreateDatabase+8b) 0x006f84c4 Module(sqlservr+2f84c4)(BackupOperation::ResolveDatabaseConfiguration+186) 0x006fff94 Module(sqlservr+2fff94) (BackupEntry::RestoreDatabase+50b) 0x005e04c0 Module(sqlservr+1e04c0) (CStmtLoadDb::XretExecute+6b) 0x00419efa Module(sqlservr+19efa) (CMsqlExecContext::ExecuteStmts+118) 0x00419a0f Module(sqlservr+19a0f) (CMsqlExecContext::Execute+16b) 2000-10-27 15:12:27.37 kernel  SQL Server Assertion:, line = 687 Failed Assertion = '0' Invalid file disposition. 2000-10-27 15:12:27.37 spid7   Error: 3624, Severity: 20, State: 1. 2000-10-27 15:30:17.34 spid7   Creating file c:\mssql7\data\pdata.mdf. 2000-10-27 15:30:17.34 kernel  c:\mssql7\data\pdata.mdf: Operating system error 112(There is not enough space on the disk.) encountered. 2000-10-27 15:30:17.39 spid7   Closing file c:\mssql7\data\pdata.mdf. 'Microsoft Windows 2000'

SQL Server 7.0 does not check for a FAT32 partition on a Microsoft Windows 2000 operating system.

'Microsoft Windows 9x'

On a Microsoft Windows 9x operating system, SQL Server 7.0 checks to see if the file system is FAT32 and then provides the following error message when it cannot create the database file:

ERROR 5148 Could not set the file size to the desired amount. The operating system file size limit may have been reached.