Altering Partition Scheme and Function

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » Altering Partition Scheme and Function

Altering Partition Scheme and Function

Rate Topic

Display Mode

Topic Options

Author

Message

mcvilbar

Posted Tuesday, October 27, 2009 5:37 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 07, 2012 12:32 AM
Points: 110, Visits: 119

Hi Expert,

I would like to know how will I alter the my partition scheme and function if it has already data on it. Hehe

Post #809671

cathy.baker

Posted Tuesday, December 15, 2009 6:58 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 9:42 AM
Points: 1,068, Visits: 294

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 »

Permissions