question

Wiregrass avatar image
Wiregrass asked

How to modify SQL 2008 PARTITIONS

[link text][1]Hello All You Very Smart People; My client has asked me to extend a project past it's expected end date of 2016. The database has PARTITIONS through 2017 and I need to extend or create new PARTITIONS through 2020. The problem I'm having is with the ALTER SCHEMA and FUNCTION - I just don't know what to do. I have the ALTER DATABASE to create the FILEGROUPs example below, but cannot figure out the syntax for the SCHEMA and FUNCTION. Experts, I need your help. The original script that created the PARTITIONS AND SCHEMA is attached. Thank you! IF NOT EXISTS(SELECT * FROM HARBOR.sys.filegroups WHERE name = 'HARBOR20181001') BEGIN ALTER DATABASE HARBOR ADD FILEGROUP HARBOR20181001 ALTER DATABASE HARBOR ADD FILE ( NAME = N'HARBOR20181001', FILENAME = N'C:\Data\HARBOR20181001.ndf', SIZE = 2048KB, MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) TO FILEGROUP HARBOR20181001 END [1]: /storage/temp/3615-harbor.sql
sql 2012sql 2008r2
harbor.sql (8.0 KiB)
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sorry - not got time to do this properly, but sounds like you need to ALTER PARTITION FUNCTION, and then ALTER PARTITION SCHEME.
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.