I have to following problem: since my database runs out of memory in a few days, I am looking for a way how to make the database use more than one file. I would like to store upcoming data in another file, which is located on a different hard drive.
I am using SQL Server 2008. Under "database properties" I already found out I can create more logical files. I created one in the filegroup
PRIMARY. Anyway, SQL Server doesn't use the new file. What can be the reason for this?
Do I have to limit the file size of my "primary" file to make it use the new file? I don't want to wait until my disc runs out of memory, hopefully somebody has some way to solve this!
Thank you very much in advance!