|
Horticulture Software Solutions Supply Chain Management for the Fresh Food Industry |
| Home | Site Map | Privacy | Links | Contact Us |
|
Essentials FAQshow BASIC-01 - Working out where to put your database servershow BASIC-02 - Where to store Tracemaster related stuff show BASIC-03 - Updating to the latest version of the Tracemaster Program show BASIC-04 - Conducting a system Audit show BASIC-05 - Finding the IP Address and Name of a computer show BASIC-06 - Making Sure Backups are Working |
||
| © 2002-2015 Horticulture Software Solutions |
at the bottom right of the screen.
if so, you are running SQL Server 2000. double click it, and you will see a screen like the following:
The top line is the name of your SQL server.
Record it in the audit document, and then you may skip to part (2).
(c) If there is no such icon, then you are running SQL Server 2005 or 2008.
Firstly, you need to know the name of the computer. Find this using FAQ BASIC03 below, or refer to your audit details.
Then go to Start > Programs > Microsoft SQL Server 2005 (or Microsoft SQL Server R2 2008) > Configuration Tools
> SQL Server Configuration Manager
The top line should display something like 'SQL Server (SQLEXPRESS)'.
The full SQL server name is the computer name followed by a backslash, then the name shown here in brackets.
For example, if the computer name is 'OfficePC01' and the SQL Server shows as above, then the full SQL server name is:
OfficePC01\SQLEXPRESS
Record this in the audit document.
(2) List of Computers
Go through each computer you will be using with Tracemaster and find the details using FAQ BASIC03.
Record the details in the audit document.
(3) List of Printers
Making a list of printers should be easy: the printer name is the name you see in Control Panel > Printers.
The type is just for noting those printers that are dedicated label printers versus a general purpose paper printer.
Finally, record the name of the computer the printer is attached to, or if it's a 'direct network' printer record its
IP address (your IT person should know how to get this).
SCANNERS: if you have barcode scanners, please see the audit item on the scanners FAQ page.
- select the 'computer name' tab, and write down the full computer name
WINDOWS 7:
- start > 'search programs and files', enter 'system' into the search text box
- in the search results, select 'system' item under the heading 'Control Panel'
write down the computer name and operating system details
(2) Finding the computer IP address:
------------------------------------
WINDOWS XP:
- start > Run, then type into the box: ncpa.cpl
- when the 'network connections' control panel page appears, right click on 'local area connection' and select 'status'.
click on the 'support' tab.
write down the 'IP Address' and 'Address Type'
- the 'Address Type' for servers, and particularly the Wavelink server if you have scanners, should be 'static'
for other computers, or if you only have one computer, it can be 'DHCP'.
WINDOWS 7:
- start > 'search programs and files', enter 'network' into the search text box
- in the search results, select 'network and sharing centre' item under the heading 'Control Panel'
- when the control panel page appears, click on 'local area connection'
- now click on the 'details ...' button
write down the 'IPv4 Address' (the IP address). if 'DHCP Enabled' is 'No' then the IP address is static.
- for servers, and particularly the Wavelink server if you have scanners, the IP address should be static.
for other computers, or if you only have one computer, it can be DHCP Enabled.
All you need to do is enter the folder location where you want the backup files to be stored, and the
name of the backup file.
You can optionally also set the number of copies kept. Once there are the specified number of backup
files in the backup folder, the oldest will be overwritten with the new backup file.
(2) Checking that the SQL Backup Files are Being Backed Up
----------------------------------------------------------
Make sure that your backup software is backing up the location where the files are stored.
(3) Testing Recovery From Your Backup Files Regularly
-----------------------------------------------------
Many businesses have had the experience of running backups daily, only to find that when their server
actually fails, they don't have all or part of their data backed up.
This is because part of their backup had been failing for some reason, and no-one noticed.
For this reason, it is very important to regularly load up a backup, and recover the files from it
to a temporary folder.
The Tracemaster SQL backup files mentioned above should be recovered, and tested for valid data.
Please see FAQ