Orders Database Restore issue

General ShopSite user discussion

Orders Database Restore issue

Postby Rick Hendrickson » Wed Jun 29, 2005 7:48 am

We have a client running Shopsite 7.0.5 Pro. The database of orders was
corrupted and we are attempting to manually restore from a backup (at the
server level.) We were not fortunate to have backed up with the Shopsite
database back up utility. We are attempting to restore files with the hard
drive backups. We restored the orders.db and the orders.p.db files at
roughly 5:00 Tueaday afternoon. I expected there to be missing orders for
the time period between when the database went corrupt and when I restored
on Tuesday afteroon. I was wrong. Orders appeared for that Tuesday, but
going back to before noon on Tuesday. This leads me to believe that there is
some sort of cache or temporary spot that orders are written to before the
are permanently written into the orders.db database.

Can anyone offer any suggestions as to which files would contain this cache
so I can restore those files from my back up and possibly capture some of
the lost orders? Your help is greatly appreciated. Thanks, Rick
Rick Hendrickson
 

Re: Orders Database Restore issue

Postby loren_d_c » Wed Jun 29, 2005 8:21 am

When orders are first placed they are stored in their own individual
files. When the merchant goes to the Orders menu in their backoffice,
the info from these files is sucked into the main orders databases
(orders.db and orders.p.db). The individual order files are then renamed
with a different extension, and stay around for approximately 7 days. If
these files are still there for the particular orders you want to get
back into your db, then you can do so simply by renaming the files to
appear as if they are new orders. For more information, see the
following ShopSite Knowledgebase article:

http://support.shopsite.com/kbase/view_ ... nID=S03931

-Loren



Rick Hendrickson wrote:
We have a client running Shopsite 7.0.5 Pro. The database of orders was
corrupted and we are attempting to manually restore from a backup (at the
server level.) We were not fortunate to have backed up with the Shopsite
database back up utility. We are attempting to restore files with the hard
drive backups. We restored the orders.db and the orders.p.db files at
roughly 5:00 Tueaday afternoon. I expected there to be missing orders for
the time period between when the database went corrupt and when I restored
on Tuesday afteroon. I was wrong. Orders appeared for that Tuesday, but
going back to before noon on Tuesday. This leads me to believe that there is
some sort of cache or temporary spot that orders are written to before the
are permanently written into the orders.db database.

Can anyone offer any suggestions as to which files would contain this cache
so I can restore those files from my back up and possibly capture some of
the lost orders? Your help is greatly appreciated. Thanks, Rick

loren_d_c
 
Posts: 2564
Joined: Fri Aug 04, 2006 12:02 pm
Location: Anywhere


Return to User Forum

Who is online

Users browsing this forum: No registered users and 12 guests