Summary:
This article provides step by step instructions for database backup and restore using the Tecom DB maintenance tool supplied with WMS Pro 4.x and above
NOTE - For WMS Pro 3.x or 2.x, see the following article:
WMS Pro Database 3.x and 2.x Backup and Restore using WMS Pro DB Manager
This article contains the following sections:
- Accessing the Tecom DB maintenance tool - how to run the backup & restore tool
- Auto Backup Process - to configure automatic backups
- Manual Backup Process - to perform a database backup
- Manual Restore Process - to perform a database restore
Accessing the Tecom DB maintenance tool
To access the Tecom DB maintenance tool, follow the following steps:
Step 1 - On the WMS Pro server, on the Windows System tray, find the Tecom DB maintenance tool, and double click it to open it (or right clicking it and choosing "Configuration" will do the same thing):
If this icon is not present in your Windows System tray, then run it from the desktop as shown below. This is installed when WMS Pro 4.x is installed on your system:
Once you run this, you should then see it in your system tray, and can run it as instructed above.
The tool should open, and it should look like somewhat like this image below, with CTPlus and WMS Pro listed at the top:
NOTE: If your window looks like the one in the image below, with "(localdb)\MSSQLLocalDB" listed at the top, then you have opened the Tecom DB maintenance tool for an older version of CTPlus (earlier than 4.x), and not the new WMS Pro / CTPlus 4.x onward Tecom DB maintenance tool:
If your tool does look like the above image, you should upgrade your CTPlus version to a current v4.x version.
Step 2 - Once you click the "Login" button to log in to the database, you should see the bottom of the window then become enabled.
Note that this uses the Windows Authentication credentials of the user you are logged into the WMS Pro server on, so you must be logged in to the WMS Pro server as a user that has permission to access the database. If you do not have adequate permission, you will get an error at this point.
Step 3 - Once you are logged in, you can then select the appropriate tab to perform the action you wish, from the following tabs:
-
Auto backup - To configure regular automatic database backups
Manual backup - Perform a manual database backup now
Restore - Perform a manual database restore now
See the following sections for an explanation of each tab, and task associated with it.
Auto Backup Process
The Auto backup tab allows an Auto backup to can be configured to backup your database on a regular schedule.
You can configure the location of the backup, and frequency of backing up using the settings on this tab.
Backups can be configured either weekly, or daily.
NOTE: Be sure to also click the "Enabled" button to enable the auto backup.
Here is an example of a backup configured for 2:00 am on a Sunday morning:
After configuring an auto backup, be sure to check the Backup path after the first time that it should have run, to ensure that it did run successfully.
Manual Backup Process
This tab allows making an immediate backup of the database to the location specified.
Step 1 - Select the "Backup path" to save the backup to, using the "Browse" button (ensure that the logged in user has write access to this location as well)
Step 2 - Press the "Save" button to save a backup to the specified location. This may take a few moments depending on the size of the database.
An example of this tab is as follows:
Manual Restore Process
Step 1 - Select the "Restore path" where the backup you wish to restore is stored, using the "Browse" button (ensure that the logged in user has read access to this location)
Step 2 - Press the "Restore" button to restore the selected backup. This may take a few moments depending on the size of the database.
NOTE: This will OVERWRITE the existing database when restoring from the backup selected.
An example of this tab is as follows:
For support on anything in this article, please reach out to our Distributors for assistance.