5. Backup Database.
Method 2 Advance.
*** Back up database first
*** Doing before Start Day / after Close day
1. On DB server station, go to C:\ProgramData\ForSoft\Tools\HeidiSQL_9.4_Portable and run 'heidisql.exe'
2. Select Network type = 'Microsoftt SQL Server (TCP/IP)
3. Check mark on 'Use Windows authenthication'
4. Click 'Open'
5. Select 'No' for Save modifications?
6. Go to File > New query tab
7. Enter this 1st query command and click 'Run'

or 'F9' from keyboard
select * from workstation
where CommType = 'Ethernet'
8. You will see a list of all workstations that currently be registered with PAX
9. Find an unused workstation that has PAX registered from the list to get a computer name
10. Go to File > New query tab again
11. Enter this 2nd query command and click 'Run'

or 'F9' from keyboard
update workstation
set PAXSerialNo = ''
,CommType = ''
,SerialPort = ''
,IPAddress = ''
,Port = 0
,BaudRate = 0
,TimeOut= 0
where Name = '(computer name from step#9)'
12. Close 'HeidiSQL' application and Done.