IntelliTrack WMS – Warehouse Management System - Manual (Page 280)

I NTELLI T RACK WMS: W AREHOUSE M ANAGEMENT S YSTEM V 8.1
User Manual
254
7. Click OK to close the form.
8. For the database connection changes to take effect, you must exit from
the IntelliTrack WMS application, and then open it again. Exit Intelli-
Track WMS by clicking Manage > Quit from the Manage ribbon.
Then, start IntelliTrack WMS by clicking Start > Programs > Intelli-
Track > WMS > WMS Workstation.
Backing Up the Database
We recommend backing up the database daily. You have two options for
backing up your data:
1. By using SQL Server Management Studio.
2. By using the IntelliTrack Utilities
Database
Backup and
Restore with
SQL Server Your WMS v8.1 application is a client server system using SQL Express or
SQL Server to handle the database and Microsoft Access to handle much
of the application. For optimum system performance, it is a good idea to
regularly back up your database. For more information on data backup and
restore with SQL Management Studio, please see
“Database Backup and
Restore with SQL Server/SQL Express” on page 333 .
IntelliTrack
Backup and
Restore
Utilities IntelliTrack backup and restore batch utilities may be used to perform a
daily database backup and a restore on the last backup. (The
databackup folder in your program directory must have proper permis-
sions in order to create a backup database with the backup utility. Make
sure that the databackup folder has the proper permissions: please refer
to
“Databackup Folder Permissions” on page 255 .)
• Use the Backup and Restore batch utilities to perform a daily database
backup and restore on the last backup.
• These utilities are found in your program folder:
C:\Program Files\IntelliTrack\WMS\backup.bat
C:\Program Files\IntelliTrack\WMS\restore.bat
• To create a backup, double-click the backup utility file backup.bat.
A backup file of the database called backup.dat is placed in the
databackup folder in the WMS program directory.
• To restore the most recent database backup file found in the databackup
folder in your WMS directory, double-click the restore utility file