Good Morning,
I am attempting to create a 10GB database with a 5GB log file using MSSQL
Server 2000 (Standard), with Windows 2000 Server as the operating system.

The d: in question has 66GB of file space, and yet I am getting this error :
Server: Msg 5149, Level 16, State 1, Line 1
MODIFY FILE encountered operating system error 112(There is not enough space
on the disk.) while attempting to expand the physical file.
Server: Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check
previous errors.

The command that I am using to create the database is this :
CREATE DATABASE [EPPB]
ON PRIMARY (NAME = N'EPPB_Data', FILENAME = N'D:\MSSQL\data\EPPB_Data.MDF' ,
SIZE = 10000, FILEGROWTH = 500)
LOG ON (NAME = N'EPPB_Log', FILENAME = N'D:\MSSQL\logs\EPPB_Log.LDF' , SIZE
= 5000, FILEGROWTH = 100)

Why would it be telling me that I cannot create this database due to size
constraints, when simple math states that 66GB - 15GB = 51GB still free
afterwards?

Thank you

Solution : The client had installed FAT32 upon it's "server"... Limiting the
size of all files down to 4GB. Once I reformatted the drive to NTFS, I
ceased to have issues.

Hi

You did not need to reformat the drive. You could have run convert.exe to
upgrade the drive to NTFS.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Rich S @SF" <RichSSF (AT) discussions (DOT) microsoft.com> wrote