Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Location
    San Francisco, CA
    Posts
    136

    Unanswered: File growth issue

    I have a situation where I am running out of disk space (3GB free) on a data drive. The drive contains only db data files, and I cannot afford to do an emergency outage to detach and move files around. I already ran “dbcc shrinkfile” and set the growth to 100mb per file for minimal db free space. Some of the dbs have multiple data files, so I was wondering if there is a way to tell the db to stop growing a particular file (the drive running out of space) and force it to grow another file(s) (on drives with more space).

    I know there is a "Maximum File Size" setting under "Autogrowth" but will it start kicking back errors if the file size has reached the max? or will it be smart enough to start filling up the other files?

    More info:
    I can add new files. All the files are part of the primary filegroup.

    Specs:
    SQL Server 2005 SP2 64-bit
    Windows 2003 SP1 64-bit
    32GB RAM
    1TB+ used space

    Any suggestions will help.
    Last edited by Reghardt; 08-21-08 at 19:20.

  2. #2
    Join Date
    Aug 2006
    Location
    San Francisco, CA
    Posts
    136
    Never mind I figured it out. You can set the max file size and it will grow the next file (assuming you have multiple files).

    Thanks!

Posting Permissions

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