Configuring automatic deletion of old database backups in U‑PROX / Goldengate 2002

Database files are named as follows:

• UProxIP.mdf / GGLite.mdf – main database
• UProxIP_log.ldf / GGLite_log.ldf – SQL Server transaction log for the main database
• UProxIP_01.mdf / GGLite_01.mdf – event log #01 for the main database
• UProxIP_01_log.ldf / GGLite_01_log.ldf – SQL Server transaction log for event log #01
• …
• UProxIP_XX.mdf / GGLite_XX.mdf – event log #XX for the main database
• UProxIP_XX_log.ldf / GGLite_XX_log.ldf – SQL Server transaction log for event log #XX

These reside in one of the following folders:

makefileКопіюватиРедагуватиC:\Program Files\A2SoftIn\UProxIP\
C:\Program Files (x86)\A2SoftIn\UProxIP\

or, for Golden Gate software:

makefileКопіюватиРедагуватиC:\ITV\Golden Gate 2002\
C:\Program Files\ITV\Golden Gate 2002\
C:\Program Files (x86)\ITV\Golden Gate 2002\

Backup file naming (for Golden Gate software, replace “UProxIPDB” with “GGLiteDB”):

• UProxIPDB_yy_mm_dd_hh_mm_ss – main database backup
• UProxIPDB_yy_mm_dd_hh_mm_ss_add_01 – event log #01 backup
• …
• UProxIPDB_yy_mm_dd_hh_mm_ss_add_XX – event log #XX backup

Note: Always at least 2 files (main + one event log), more if additional logs exist.
yy_mm_dd_hh_mm_ss = year_month_day_hour_minute_second when the backup started.

When restoring, specify only the main backup file (UProxIPDB_yy_mm_dd_hh_mm_ss), but all related backup files must be present in the same directory. You may also use the automatic backups for restoration.

See the Q&A on backups at:
https://access.u-prox.systems/uk/putannia/
(Review items #4, #5, #6, and #14 on reconfiguring automation.)

Automatic deletion of old backups

Create a new Basic Task named “Remove old DB backup” to run daily at 05:00.

Download RMBAKscript.zip
– https://drive.google.com/file/d/1ay8GykshzgDMM2_npRZ7XcNA06huxB9H/view?usp=share_link

Unzip, and copy the script folder to C:\script\oldbackup.bat

Edit the script parameters in a text editor as needed.

By default, it deletes files older than 60 days from:makefileКопіюватиРедагуватиC:\ProgramData\A2SoftIn\UProxIP\ C:\ProgramData\ITV\Golden Gate 2002\

Open Task Scheduler (Start → Run → taskschd.msc → OK)

5. Open the properties of the created task and set additional authorization parameters.