We are putting our first DW together. One of the consultants, not familiar with the MS SQL database, suggested we consider "parititioning" our data for ease or reloading, distaster recovery etc. His idea was that we could parition the data based on, say, year, and that way, in case of a disaster, we would only need to reload that year's worth of data from our backups. (So I guess he is talking about software partitioning, not hardware partitioning?)
I can't imagine how this approach wll work with our nightly backup strategy or the changes the need to be made to the DW import code to to handle these partitons. Furthermore, in case of a disaster how is one to even know what parititon(s) to reload. (I'd be incliined to reload the entire warehouse to make sure I got everything!). I'm lost. Any thoughts you can share on this headache will be much appreciated!
barkingdog
Not sure if you are asking question on the right place. This forum is specifict to issues related to Analysis Services only.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
My mistake -- I will contiue to look for the the DataWarehousing newsgroup!
Barkingdog
No comments:
Post a Comment