Sales Data .bck file & how to append it to newly created file

Through a series of events too distressing to go into here we seem to have lost a .bck file created from exisiting sales history when we needed to re-install RMS on our office server. What we do have is sales data for the past few weeks, and a .bck file from 3 months ago.

The question is how we would go about integrating the 3 month old .bck file into the current data in RMS. Our RMS guy is not sure how to do it, or if it can be done. If integration is not possible, is there a way to substitute the older file (a year's sales) for the newer data (only a month)???

-- WineGuy

What happened was that the RMS guy was trying to set up a mirror array for me on the server and 'inadvertantly' erased all data on the one drive where it had been stored. He said he had backed everything up to either the floor system or my laptop, but I can't find a .bck file from that time frame, except a relatively small one (6gb) that is probably only the data collected while the POS was in offline mode..

We were not routinely making backup files because he had told me that all data was always available on both the POS system and the server. (Actually, the reason I wanted the mirror was for an automatic backup and he had argued that I didn't need it). Now I find that his statement did not include sales data (I am not happy!).

Anyway, he is coming by to see if he can find any other backup files on either the POS system or my laptop, but we may have lost 3 months of sales data. I just want to know that we can integrate the last found backup into what has been collected since the server drive was erased. He sounds unsure as to if/how to do that.

WineGuy

"Jeff @ Check Po> WineGuy,

and/or re-installing does not delete the database.

to your current backup?

One more question.....

If the sales data for that 3 month period was lost does that mean that all inventory (on hand) information is now incorrect, or would the sales have subtracted at the time and still be reflected correctly today?

and/or re-installing does not delete the database.

prior to your current backup?

can be done.

newsgroup reader to