Techniques for storing SQL Server data online and for backing up the server
0
Q:
Techniques for storing SQL Server data online and for backing up the server
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: Oct 26 2009  3:50 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
47440 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Oct 27 2009  3:36 AM GMT by Mrdenny   47440 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0