Our SQL server has run out of space on the C:\ drive. There is around 20gb space free on the G:\ drives (currently mainly used for Log files)
I created a Data File on the G:\ drive, on the same file group as the large file which is on the C:\ drive.
I still get errors saying the data file is full etc...
Have i missed something?
(this is a SQL 2000 database - i'm using Management Studio from my workstation however)
Please see screenshot to show layout of files: http://twitpic.com/wnjl1/full