How to reduce the size of .log/.ldf files and optimize the U‑PROX database

Share and save
How to reduce the size of .log/.ldf files and optimize the U‑PROX database

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.

You may also like