Archive Data after Partitioning

• Garry47

  Grasshopper

  Points: 20

  More actions

  August 10, 2010 at 10:25 pm

  #225918

  Hi All,

  I need your help...

  I Implemented data partitioning in SQL Server 2005. There were 2 tables that had so much data and I partitioned them quarterly because data was coming in datetime.

  I created 4 filegroups and attached 4 files to each filegroup. Now data is partitioned in 4 quarters and I want to archive first quarter. I need your help in archiving first quarter.. please help guys...

  I thought I could detach the file from filegroup and keep it on another drive and when i need it i can attach it... but I'm not finding it feasible...please help.. if you have any idea how i can archive the data please respond..

  TC guys

  Garry

• pveilleux

  Ten Centuries

  Points: 1363

  More actions

  August 11, 2010 at 2:13 pm

  #1205705

  Sounds similar to the sliding window scenario Microsoft draws up:

  http://msdn.microsoft.com/en-us/library/aa964122%28SQL.90%29.aspx

  Take a peek. This might be helpful...