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
Author
Message
Posted Tuesday, October 27, 2009 5:37 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

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: Friday, October 10, 2014 12:27 PM
Points: 1,141, Visits: 348
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