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
Software/Hardware used:
SQL Server
ASKED:
Oct 26 2009 3:50 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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.
