Hi list,

We have a customer saves 2 years worth of data ---- they only use 1 year of data frequently, while the other year's data was only be there in case they need them. Now they feel their db is kind of too big and ask us if we can keep the size of the db down while still keep 2 years of data somewhere so they can access it when needed.

Here is what I thought:
They can export part of the data (which they don't use much) to either another db or a text file which could be saved on tapes. After make sure the data are exported successfully, they can permanantly delete this part of data from their db thus make the db size about half of what they have now. And in case they need to use the old data, they can just import that part of data from either the other db or external device.

How is that sound to you? As to export to another db or text file, which one is more preferable if customer has no preference? I think text file maybe easier for the customer since in order to export to another db, they need to create schema on that db first before export data (since export won't create schema), right?

Any other suggestions?

Thanks a lot,
Elaine








MS Sql Server LazyDBA home page