Unpack the utility shrink_db_all_modif.bat from the archive shrink_db_all_modif.zip into the database directory (C:\Program Files (x86)\A2SoftIn\UProxIP
), and, as needed, run shrink_db_all_modif.bat from that directory as Administrator. Before running the utility shrink_db_all_modif.bat, stop all client applications, the service “U-PROX IP Equipment Service” and “U-PROX IP Web Service.”
The utility archive is available at:
https://drive.google.com/file/d/1db_ZpLU5S_aaZ_3Ol2-9VmnndQ0Sc3bw/view?usp=sharing
The utility connects to the SQL Server by the instance name (Instance Name) — by default SQLEXPRESS. If a SQL Server with a different instance name is installed, that instance name must be specified on the command line when launching the utility, for example:
КопіюватиРедагуватиshrink_db_all_modif.bat .\SQLEXPRESS
(or inside the utility shrink_db_all_modif.bat, edit in a text editor the line:
if "%1"=="" set SRV=.\SQLEXPRESS
— replacing “SQLEXPRESS” with the actual value)
Database files are named:
- UProxIP.mdf — main database
- UProxIP_log.ldf — SQL Server transaction log for the main database
- UProxIP_01.mdf — event log 01 for the main database
- UProxIP_01_log.ldf — SQL Server transaction log for event log 01
- …
- UProxIP_XX.mdf — event log XX for the main database
- UProxIP_XX_log.ldf — transaction log for event log XX
These reside in the directory “C:\Program Files\A2SoftIn\UProxIP\” or “C:\Program Files (x86)\A2SoftIn\UProxIP\”. A database backup looks like:
- UProxIPDB_yy_mm_dd_hh_mm_ss
- UProxIPDB_yy_mm_dd_hh_mm_ss_add_01
- …
- UProxIPDB_yy_mm_dd_hh_mm_ss_add_XX
where UProxIPDB_yy_mm_dd_hh_mm_ss
— main database and UProxIPDB_yy_mm_dd_hh_mm_ss_add_XX
— event logs, and there are always at least 2 backup files (depending on the number of additional event logs). yy_mm_dd_hh_mm_ss
= year, month, day, hour, minute, second when the backup started.
When restoring backups, specify only the main database UProxIPDB_yy_mm_dd_hh_mm_ss, but all files from the backup must be present in that directory. You can also use automatic backups for restoration.
See the information on the website, on the “Downloads” → “Q&A” page regarding software backups and working with them — https://access.u-prox.systems/uk/putannia/
– items #4, #5, #6, and #14, about reconfiguring automation.