Can you do a partial archive while retaining records since archive date as active

Mar 29, 2010 5 Replies

I have 16 years of data and a 65 meg datafile. Was wondering if I set my system clock to 2005 whether I could then archive everything before 12/31/04 and keep everything since in my active registers?



This, if possible, would certainly speed up the opening of the file.



Gary



----------------------------------------------- Gary .


Why not save a copy of your 65MB file to whatever medium you choose, delete all transactions prior to 2005, and use the resultant file as your "current" file?

If I did it that way I would not have restore capabilities if I needed to put it back together.

----------------------------------------------- Gary .

In a world of gigabytes, terabytes and petabytes, 65 meg just doesn't seem very big. Is it causing you a problem?

I doubt that you could put it back together in any case. Even if you could, I doubt that it would be easy or neat. Setting the system clock back 5 years does not sound like a good idea. Most software is not expecting to find multiple years of future transactions.

Out of curiosity, I did some timing on opening a 300MB file with 30 years of data versus a 15MB file with 8 years of data

Time to open file after a cold boot:

300MB = 11.8 sec 15MB = 3.4 sec

Time to reopen file:

300MB = 8.7 sec 15MB = 2.8 sec

Doesn't Quicken has this ability built-in? File=>File Operations=>Year-End Copy The box on the bottom of new pop-up window will let you select/type

12/31/04 as the last day of data to archive. The current file could be left intact or be truncated - your choice.

Am I missing something here?

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required