Post reply

Data Archiving

  • March 31, 2009 at 1:25 am

    #130242

    Dear Friends,,,,

    I wanted to know about Data Archiving.....In fact we have one situation in which we want to keep only 3years older data on our production server...so as any data gets older then 3 years it should get deleted from production server and it should move to archive server.....all this should be automated....

    I heared that we can achive it by data Archiving... but please provide me some information on it...

    So can you suggest me the ways and tools if any?

    Thanks in advance......

    Regards,

    Mithun Gite

  • March 31, 2009 at 2:42 am

    #968902

    I don't know if this is exactly what you desire to achieve, but you could take a look at table partitioning. There's an interesting article in technet that could help you: http://technet.microsoft.com/en-us/library/aa964122.aspx.

    Another useful resource is Nigel Rivett's article: http://www.simple-talk.com/sql/sql-server-2005/partitioned-tables-in-sql-server-2005/ .

    You can read also this one: http://www.sqljunkies.com/article/f4920050-6c63-4109-93ff-c2b7eb0a5835.scuk

    Hope this helps

    Gianluca

    -- Gianluca Sartori

  • March 31, 2009 at 5:52 am

    #969000

    I'm 100% in agreement with Gianluca, to implement an Archive and Purge process nothing beats table partitioning.

    Just archive the appropriate partition and get rid of it, that's fast, safe and clean.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • March 31, 2009 at 6:09 am

    #969008

    Though partitioning is the best option for archiving data, it is only available in Enterprise & Developer editions of SQL Server.

    --Ramesh

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply