Ok so here it goes.
I need to change the default location of the .mdf and log files for MOSS 07.
I have changed it in SQL server Management studio and have tested this by creating a test database which works like I should be.
However when I create a new database in MOSS it continues to create it in the old location c:\blahblah.
THis is a problem as c:\ is a small 30G partition and have now run out of room because I didnt think about default location. (its cool, I know how to move the databases).
any help please would be more than appreciated.