How to warehouse data that is not needed from MS SQL server

Posted by I__ on Server Fault See other posts from Server Fault or by I__
Published on 2011-11-23T16:18:09Z Indexed on 2011/12/01 2:01 UTC
Read the original article Hit count: 493

I have been asked to truncate a large table in MS SQL Server 2008. The data is not needed but might be needed once every two years. It will NEVER have to be changed, only viewed.

The question is, since I don't need the data on a day-to-day basis, what do I do with it to protect and back it up?

Please keep in mind that I will need to have it accessible maybe once every two years, and it is FINE for us if the recovery process takes a few hours.

The entire table is about 3 million rows and I need to truncate it to about 1 million rows.

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2008