How to archive old data on top of existing table partition?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » How to archive old data on top of existing...

How to archive old data on top of existing table partition?

Rate Topic

Display Mode

Topic Options

Author

Message

Thanh Ngay Nguyen

Posted Wednesday, January 16, 2013 3:14 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 15, 2013 11:03 AM
Points: 12, Visits: 347

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

Bhuvnesh

Posted Thursday, January 17, 2013 12:05 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1408172

SQL_By_Chance

Posted Thursday, January 17, 2013 12:44 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 01, 2013 1:11 PM
Points: 104, Visits: 247

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 »

Permissions