Post reply

Database Archiving Tool

  • March 12, 2009 at 1:19 pm

    #128961

    Hi Folks,

    We are using SQL server 2005 in our datawarehousing. There is a need for us to archive some old data from our database in order to minimize the database size. Do you guys know any effecient database archiving tool that you know of?

    I would appreiciate your response on this.

    Thanks!

  • March 12, 2009 at 3:36 pm

    #958791

    I would absolutely consider just using partitioning for a situation of this nature.

    This is a great Whitepaper on setting it up and managing partitioning in SQL 2005

    http://msdn.microsoft.com/en-us/library/ms345146.aspx#sql2k5parti_topic6

    This focuses more on staying within the same database, but you could certainly adapt this technique in a way that you could move the older data to a separate database drop them off from the original as needed. Obviously this is not a third party tool but because you would be creating this yourself, I think it would also give you better flexibility will be far easier to deal with whatever issues you might come up with than a third party which you would have no control over.

Viewing 2 posts - 1 through 1 (of 1 total)

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