PRB: Error Message Occurs When You Create or Expand a Database on a FAT32 Partition (281220)


The information in this article applies to:

  • Microsoft SQL Server 7.0
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:<bckmeta.cpp>, 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.

REFERENCES

Modification Type:MajorLast Reviewed:8/16/2006
Keywords:kbprb KB281220
©2004 Microsoft Corporation. All rights reserved.