SQLTeam.com | Weblogs | Forums

Move partitioned Tables to new Filegroup


#1

Hi,
I have a lot of tables which
are partitioned. Now I would move these entire tables (over 100) into a
new filegroup (switch out/in). ... Foreach Day...move partition on filegroup old to partiton filegroup new ...
What is the best way to do this? Each table is partitioned by days for 2 years.
The
Function: CREATE PARTITION FUNCTION [pf_2YearDays] (datetime) AS RANGE
RIGHT FOR VALUES (N'2016-05-23T00: 00: 00.000 ', N'2016-05-24T00: 00:
00.000' ...

Best Regards
N‌‌‌icole