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?
I can add new files. All the files are part of the primary filegroup.
SQL Server 2005 SP2 64-bit
Windows 2003 SP1 64-bit
1TB+ used space