Techniques for storing SQL Server data online and for backing up the server

Tags:
Backup
Online Backup
SQL Server backup
SQL Server backup and restore
For a banking application, I would like to keep 10 years worth of data using SQL Server. I would like to keep two years online and backup the other eight years. What are some techniques to do this?

 



Software/Hardware used:
SQL Server
ASKED: October 26, 2009  3:50 PM
UPDATED: October 27, 2009  3:37 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

There’s no offline storage capabilities native to SQL Server. EMC has a product called database extender which can help with this archiving to offline storage.

With storage being as cheep as it is these days, most people will setup some sort of partitioning (either using the native table partitioning if they have SQL 2005+ Enterprise Edition, or some sort of manual archiving process) to handle this with the current data on fast expensive storage, and the older data on slower much less expensive storage.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following