Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Altering Partition Scheme and Function Expand / Collapse
Posted Tuesday, October 27, 2009 5:37 PM


Group: General Forum Members
Last Login: Monday, July 29, 2013 8:34 PM
Points: 110, Visits: 120
Hi Expert,

I would like to know how will I alter the my partition scheme and function if it has already data on it.
Post #809671
Posted Tuesday, December 15, 2009 6:58 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 30, 2015 2:48 PM
Points: 1,141, Visits: 391
I am also having issues with modifying partition schemes using existing data.

Here's what I have done:
1. Created filegroup and added files
2. ALTER PARTITION SCHEME partition_scheme_name NEXT USED filegroup_name
3. ALTER PARTITION FUNCTION partition_function_name SPLIT RANGE (value).

What happened is that SQL Server moved the existing data from one filegroup to another. When I look at the partition scheme it does not appear that the new filegroup is included.
Post #834464
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse