Database Archiving Tool

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Database Archiving Tool

Database Archiving Tool

Rate Topic

Display Mode

Topic Options

Author

Message

SqlSavvy

Posted Thursday, March 12, 2009 1:19 PM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, March 16, 2012 3:51 PM
Points: 83, Visits: 300

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!

Post #674636

Mike - CI

Posted Thursday, March 12, 2009 3:36 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 10, 2013 2:07 PM
Points: 197, Visits: 1,028

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.

Post #674785

« Prev Topic | Next Topic »

Permissions