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

How to archive old data on top of existing table partition? Expand / Collapse
Author
Message
Posted Wednesday, January 16, 2013 3:14 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 29, 2014 4:57 PM
Points: 18, Visits: 409
Hi Experts,

Can someone give me some high-level direction on how to approach this?

I'm given a task to do these 2 things:
- 1. Separate customers data across multiple filegroups using table partition (based on CustomerID)
- 2. Archive customers data (using table partition if possible) (based on CreatedDate)

I have a very clear idea on how to do either 1 or 2, but not both. Is that even possible to partition on top of partition? If not, what's the best way to approach this?

Thanks,
Thanh
Post #1408095
Posted Thursday, January 17, 2013 12:05 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:26 AM
Points: 2,840, Visits: 3,963
Thanh Ngay Nguyen (1/16/2013)
I have a very clear idea on how to do either 1 or 2, but not both.
First you need to perform 1st then monthly job/manual intervention will move the data from partitioned table to destination table (partitioned or non- partitioned) , if you know both the step very well then whats the problem ?

Thanh Ngay Nguyen (1/16/2013)
Is that even possible to partition on top of partition?
What is this ?


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1408172
Posted Thursday, January 17, 2013 12:44 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, July 25, 2014 10:05 AM
Points: 122, Visits: 292
Hi,

You can switch partitions if your idea allows this or TRANSFER the partition to other. PLease follow the following url for more details.

http://msdn.microsoft.com/en-us/library/ms142159.aspx
http://msdn.microsoft.com/en-us/library/ms191160(v=sql.105).aspx


______________________________________________________________________

Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”
Post #1408187
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse