We have space crunch in our F Drive and our H drive. We have added one more drive - I drive and it has 500 GB. Can we add the new MDF 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 H drive?
The current MDF 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