The Back-up Action
System Design
Hardware
1 server, 4 registers (computerised) & 4 PC workstations [2 in the office,
1 in the dock & 1 at the owner’s home, which can connect to the network
through a dial in connection]. They use a windows NT platform. The PC’s
all have CD-RW drives, hard drives and 3.5” floppy drives. There
is one networked laser printer located in the main office and one of the workstations
is connected directly to a dot matrix printer that is used to print orders.
There is also a laser printer connected to the PC at the owner’s home.
Software
As mentioned above there are four programs that are used by the supermarket
- logistics, orders/accounting, payroll and office.
Data
The logistics program stores its stock quantity information and price look
up tables on the server. Various elements of program itself are stored on
the server, 3 PC’s and the 4 register/computers on hard drives. All
sales data is stored as it is captured simultaneously in the registers and
the server.
The orders/accounting program is located on the server and 3 PC’s, it stores its data on the server.
The payroll program is located on one of the PC’s and stores its data on the PC.
The office programs are stored on every PC and data is kept on a combination of the server/locally.
Media
The supermarket uses CR-WR drives, and when this report refers to CD it means
rewritable
Processes
Hardware
The supermarket needs to enter into a service agreement with an IT services
company to supply assistance in the form of maintenance, help desk and parts
supply/replacement as required. This service should be provided 24 hours a
day within a few hours in respect to the server and registers, and within 48
hours for the PC’s and other hardware.
It is suggested that a spare register/computer be stored at the owner’s home, with a Sydney ADSL provider for access.
The Server, PC’s and Register/computers should all be powered through a UPS. AA testing program should be set up to ensure that the UPS is functioning, this should be done in line with the manufacture’s specifications.
Software
The original disks for the 4 software programs should be located at the accountant’s
office together with any registration information. Copies of the programs should
be kept in both the safe in the supermarket office and the owner’s home,
in addition to being installed on the appropriate workstations and/or server.
Data
LOGISTICS PROGRAM
The price look-up table is stored on the server and should be fully backed up onto CD after any changes (including additions and deletions). This CD should be stored in the office safe. Once a new CD is created the old CD from the safe should be taken to the owners home for storage (which will replace the one already there).
If communication with the Server goes down during the day, the price look-up table will not be contactable - and prices will need to be manually entered. As the server comes back on line, the sales data stored locally can be sent through to the server, this will over-ride any different information in the price look-up table.
As a sale/return transaction occurs the information should be automatically stored by the register internally on the hard-drive and sent to the server for storage. At the end of each day the register close down should resend all the information stored for that day to the server as one parcel, as part of the application program, the server should then check this information against what it has received throughout the day. Once all information is received and verified from each register the data should be stored on the server’s hard drives. (The information remains in the registers’ hard-drives over night, prior to being wiped when they are set up for business the next day. The information is also kept on the journal roll printouts from the registers. Triple redundancy!) At the end of each day the data should also be copied from the server onto CD, and taken home by the owner. The following day, the CD from 2 days prior should be brought back to the office for rewriting.
Every Saturday night, all sales information for the week should be stored onto two CD’s – one for the office safe and the other for the owner’s home. (These should be kept until the monthly CD is created, at which stage these weekly CD’s may be rewritten.)
At the end of every month the process above should be run for the whole month’s data, but with 3 CD copies, this time the additional one goes to the accountant for storage. (These monthly CD’s should be kept until the Half-Yearly Back-up is done, at which time the monthly CD’s can be rewritten.)
The same process is done for the data collected on a half-yearly basis (the business presents their BAS monthly). At this time the data on the server is erased. Half-Yearly discs are permanent records and kept for 7 years.
All system or user passwords are stored in the safe, accountants and owner’s home.
back to Computer Hardare shop Sydney
End of thread....please return to the home page for more on web design inSydney.