Скрипт резервного копирования базы Меркурия

[admin]

set "currentTime=%Time: =0%"
set now=%date:~-4%%date:~3,2%_%date:~0,2%_%currentTime:~0,2%_%currentTime:~3,2%_%currentTime:~6,2%

set user=SYSDBA
set password=masterkey
set database_name=C:\base\mercury.fdb
set backup_name=D:\BACKUP\mercury\
set ext=.fbk

set backup_filename=%backup_name%_%now%%ext%
echo %backup_filename%


"C:\Program Files\Firebird\Firebird_2_5\bin\gbak.exe" -user %user% -password %password% -b %database_name% %backup_filename% -v -y %backup_name%_log_%now%.txt

[m0rh0ld]

Я сделал бэкап таким скриптом:

Код: Выделить всё

@echo off
set "currentTime=%Time: =0%"
set now=%date:~-4%%date:~3,2%_%date:~0,2%_%currentTime:~0,2%_%currentTime:~3,2%_%currentTime:~6,2%
 
set user=SYSDBA
set password=masterkey
set database_name=C:\mercury\base\mercury.fdb
set backup_name=D:\BACKUP\mercury\
set ext=.fbk
 
set backup_filename=%backup_name%_%now%%ext%
echo %backup_filename%
 
"C:\Program Files\Firebird\Firebird_2_5\bin\nbackup.exe" -user %user% -pas %password% -B 0 %database_name% %backup_filename%


Чуть позднее допишу скрипт для ежедневного обслуживания БД (сжатия и восстановления базы).