Results 1 to 11 of 11
  1. #1
    Join Date
    Nov 2003
    Posts
    9

    Unanswered: Can't create new database -> no disk space (os error 112)

    Hello everybody

    Had some problems yesterday with a full transaction log. Was able to solve it by following microsofts knowledge base article n° 272318.

    However, today I'm trying to create a new DB using the enterprise manager and get this error:

    d:\databases\HERCULES_1_Data.MDF: Operating system error 112(Es steht nicht genug Speicherplatz auf dem Datenträger zur Verfügung.) encountered.

    The free disk space is > 60GB. That's by far enough... I only need 1-2 GB.

    Any ideas what's wrong here?

    Thanks anyone in advance for some guideance.

    Renaud

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Are you sure both the log and the data files were being created on D? How much space is left on your C drive?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Nov 2003
    Posts
    9
    Yes, both files on D:\ but not created at all of course, because of the insufficient disk space error message.

    However, on C:\ there's 1.6 GB left. But IMO this shouldn't matter and not be related to the error message, right?

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    How are you trying to create this database? By a script, or by Enterprise Manager?

  5. #5
    Join Date
    Nov 2003
    Posts
    9
    I'm using the enterprise manager

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    How big is your model database? It should be about 1 or 2 MB in size.

  7. #7
    Join Date
    Nov 2003
    Posts
    9
    According to the database properties, general tab, the model database is 1.25MB in size with 0.27MB of free space.

  8. #8
    Join Date
    Nov 2003
    Posts
    9
    huh... exec xp_fixeddrives tells me:

    On C, 1395MB free space
    On D, 1MB free space

    How can I fix it?

  9. #9
    Join Date
    Nov 2003
    Posts
    9
    ... and EXEC xp_cmdshell 'dir d:\' gives me back:

    1.298.432 Bytes free

    Opening a command line (DOS box) and entering "dir d:\" gives me back:

    64.280.199.168 Bytes free

    ?!?!?

  10. #10
    Join Date
    Nov 2003
    Posts
    9
    FOUND IT!! There were disk quotas activated on our SBS 2003 Server. Didn't realize that before. Seems to be a default setting when creating new user accounts on Windows. Our SQL Server runs under its own windows account. Wasn't aware of this, now I know better!

    Thanks a lot for your help.

    Renaud

  11. #11
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Thank you for reporting back the fix to a problem the rest of us may very well encounter.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •