SQL Server space in MDF file with multiple files and one Primary file We have space issues in our F: and our H: drive. We have added one more drive - I: drive with 500 GB capacity. Can we add the new database file in the I: drive and set the autogrowth option in the F: drive and the H: drive so that the new data will use the I: drive?
The current database files are as follows:
F:\MSSQL11.MSSQLSERVER\MSSQL\DATA\test.mdf
G:\MSSQL11.MSSQLSERVER\MSSQL\Log\test1_log.ldf
H:\MSSQL11.MSSQLSERVER\MSSQL\Data\test123_1.ndf
H:\MSSQL11.MSSQLSERVER\MSSQL\Data\test_2.ndf
Yes, you can go ahead with that.

Limit the other secondary files (Disable Autogrowth) and create new ndf file in the new drive. This will resolve your space issue.