Hi All,
I am having a scenario in which I am having a table which is partitioned. Every week a new partition is added to the table and consequently a new ndf file is added to the DB(new filegroup) and sometimes existing partition is restated but now I'm having
a disk space crunch on the drive where I'm placing the partitions. So I've safely moved the new partition allocated file path to the new drive with ample amount of space.
But now I've to restate some of the existing partitions as well but unfortunately there's no enough space left on the drive accomodating those partitions. So, here's my question :- I'll be taking the DB offiline and will move the partition to be restated
to another drive and alter the database and will map the that patition's filepath afterwards. Does it require any other changes in the system partition tables (partition, partition_scheme etc) or any where else?
Quick responses are highly appreciated.
Thanks in advance.
Kusum