November 4, 2009 at 12:32 pm
I have database with 100's of partitions ( a partition for a month) , how can i add or delete partitions on 2TB database.
example:2TB of databases containing 20 yrs of data partitioned for each month now i want to split that into 2.
November 4, 2009 at 2:39 pm
Tara-1044200 (11/4/2009)
I have database with 100's of partitions ( a partition for a month) , how can i add or delete partitions on 2TB database.example:2TB of databases containing 20 yrs of data partitioned for each month now i want to split that into 2.
Split into 2 ?
2 databases or each month in 2 ?
If you want to split in 2 databases, check BOL for partial restores.
If you want to actually split each partition in 2, you'll have to deal with existing data, which will be a huge overhead.
If you have the means (space), maybe it's better to create a new db and prepare it to host all partitions with the new boundaries and then pull over the data on a partition by partition basis.
Make sure you pre-size you partition files !!
- Books online has good partitioning guidelines.
- check Kimberly's very good white paper on partitioning
http://msdn2.microsoft.com/en-us/library/ms345146.aspx
- google for "DELANEY Partition Magic"
- have a look at http://www.sqlservercentral.com/Forums/Topic417556-146-1.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply