Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2008
    Posts
    10

    Unanswered: SQL Server 2000 Out of DiskSpace

    Had an issues with our database where the data file had no space avaibile. When I check the propteries it showed that the space avaibile was 77mg. It turn out that this was the index file and the log file space only. Had the data files set to auto grow by 10%. but it was not gowing or somethine as it ran out of space. To sove the issue we changed the space allocated. Does anyone know of a script or something to prevent this from occuring.


    Thanks
    Chris

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    If its using that much space, its because it needed that much space.
    Disks are cheap, man. Get some more storage.
    If it's not practically useful, then it's practically useless.

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

  3. #3
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Quote Originally Posted by cbhildebrand
    Had an issues with our database where the data file had no space avaibile. When I check the propteries it showed that the space avaibile was 77mg. It turn out that this was the index file and the log file space only. Had the data files set to auto grow by 10%. but it was not gowing or somethine as it ran out of space. To sove the issue we changed the space allocated. Does anyone know of a script or something to prevent this from occuring.


    Thanks
    Chris
    Change the growth to MB not %, so if allocates space in fixed amounts.

    I run xp_fixeddrives and email the results.

Posting Permissions

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