I inherited an old SQL Server 2000 instance running 8.00.239 (SQL Server 2000 Enterprise edition / Sp4)
One of the Databases (created back in 2007) has it's Data and log files on the C: Drive. Obviously this is not ideal - having the DB files on the same partition as the operating system - and I have already moved the logfile off to another drive.
My Data File however is 25GB and I do not have enough room on the other drive to move it so I am thinking I need to add another datafile and set the datafile on the C: drive to stop growing.
My plan is to add an additional Datafile, but I have a couple of questions:
1 - should this second datafile be in the primary file group ?
2- what settings do I have to change in order for any growth to stop happening in the datafile that resides on the C drive?
Thanks in advance