I have a huge SQL Server archival database (
MISArchival): 250GB and it's sitting on a
E:\ drive which has only 30GB space left.
I have to purge/move out some more data from production MIS database to this archival database (
Now I have another drive which is
I:\ drive and have around 200GB of space.
My question is: how can I make/add another
.mdf file on
I:\ drive and make sure next time I insert data to this archival database, it starts to write to this new
.mdf file created on the
I:\ drive and NOT to the
E:\ drive ?
I need another
.mdf file at a different location due to space issue: