@echo off rem ÔÀÉË ÄËß ÐÅÇÅÐÂÍÎÃÎ ÊÎϲÞÂÀÍÍß ² ÍÀÑÒÓÏÍÎÃΠ²ÄÍÎÂËÅÍÍß ÁÀÇÈ ÁÅÇ ÌÓÑÎÐÀ (áåç ïîïåðåäí³õ íå ïîòð³áíèõ äàííèõ) rem ÄËß ÇÀÏÓÑÊÓ ÖÜÎÃÎ ÏÐÎÖÅÑÓ ÏÎÒвÁÍÎ Ç̲ÍÈÒÈ ÏÎÇÈÖ²¯ ÍÀËÀØÒÓÂÀÍÜ ÍÀ ÂÀز ÄÀÍͲ. rem ϲÑËß ÒÎÃÎ ÇÁÅÐÅÃÒÈ Ç̲ÍÈ. rem ÏÅÐÅÉÌÅÍÓÂÀÒÈ ÄÀÍÈÉ ÔÀÉË Ó ÐÎÇØÈÐÅÍÍß "BAT" (ÍÀÏÐÈÊËÀÄ "REZERV.BAT") rem ÇÀÏÓÑÒÈÒÈ ÔÀÉË. rem *************************************************************************** rem ØËßÕ ÄÎ ÏÀÏÊÈ ÄÅ ËÅÆÈÒÜ ÁÀÇÀ ÄÀÍÍÈÕ, ÁÅÇ Ê²ÍÖÅÂÎÃÎ ÇÍÀÊÓ "\". (çì³í³òü ïðè ïîòðåá³) set pathdata=D:\BOVSOFTTAXI\DATA rem ÍÀÇÂÀ ÁÀÇÈ ÄÀÍÍÈÕ (çì³í³òü ïðè ïîòðåá³) set basename=TAXIDEMO.FDB rem ÂÊÀƲÒÜ ØËßÕ ÄÎ ÏÐÎÃÐÀÌÈ ÐÅÇÅÐÂÓÂÀÍÍß ÄÀÍÈÕ ÄÎ ÂÀØί ÂÅÐѲ¯ FIREBIRD (çì³í³òü ïðè ïîòðåá³, ÏÎ ÇÀÌÎÂ×ÞÂÀÍͲ ÄËß ÂÅÐѲ¯ 2.5) set gbak="c:\Program Files\Firebird\Firebird_2_5\bin\gbak.exe" rem ÍÀËÀØÒÓÂÀÍÍß ËÎòÍÀ ² ÏÀÐÎËß ÑÅÐÂÅÐÀ FIREBIRD set baseuser=SYSDBA set basepass=masterkey rem ÇÀÏÓÑÊ ÏÐÎÖÅÑÓ ÐÅÇÅÐÂÍÎÃÎ ÊÎϲÞÂÀÍÍß rem ÁÓÄÅ ÑÒÂÎÐÅÍÈÉ ÔÀÉË Ó ÂÈÃËßIJ (íàïðèêëàä rezerv-10.10.2012-20-41-10.fbk) ÍÀ ÄÀÍÓ ÄÀÒÓ ² ×ÀÑ (ßÊÈÉ ÑÒÂÎÐÈÒÜÑß Ó ÏÀÏÖ² ÐÎÇ̲ÙÅÍÍß ÖÜÎÃÎ ÔÀÉËÀ). set mytime=%time% set mytime=%mytime:~0,2%-%mytime:~3,2%-%mytime:~6,2% set myrezervfile=rezerv-%date%-%mytime% %gbak% -b -v -user %baseuser% -password %basepass% "%pathdata%\%basename%" "%myrezervfile%.fbk" rem ÇÀÏÓÑÊ ÏÐÎÖÅÑÓ Â²ÄÍÎÂËÅÍÍß ÁÀÇÈ ÄÀÍÈÕ rem ÁÓÄÅ ÑÒÂÎÐÅÍÈÉ ÔÀÉË Ó ÂÈÃËßIJ [NEW_TAXI.FDB] (ßÊÈÉ ÑÒÂÎÐÈÒÜÑß Ó ÏÀÏÖ² ÐÎÇ̲ÙÅÍÍß ÖÜÎÃÎ ÔÀÉËÀ). %gbak% -c -v -user %baseuser% -password %basepass% "%myrezervfile%.fbk" "NEW_TAXI.FDB" rem *************************************************************************** rem ÁÓÄÅ ÑÒÂÎÐÅÍΠ²ÄÍÎÂËÅÍÓ ÁÀÇÓ Ç ÂÀØÈÌÈ ÄÀÍÍÈÌÈ ÁÅÇ ÌÓÑÎÐÀ ßÊÈÉ ÁÓÄÅ ÍÀÇÈÂÀÒÈÑß NEW_TAXI.FDB rem ÏÅÐÅÉÌÅÍÓÉÒÅ ÁÀÇÓ NEW_TAXI.FDB ÍÀ ÒÓ ÍÀÇÂÓ Ç ßÊÎÞ ÂÈ ÏÎÏÅÐÅÄÍÜÎ ÏÐÀÖÞÂÀËÈ (ÇÀ̲ͲÒÜ ÎÐÈòÍÀËÜÍÓ ÁÀÇÓ), rem ÏÎÏÅÐÅÄÍÜÎ ÍÀ ÂÑßÊ ÂÈÏÀÄÎÊ ÎÐÈòÍÀËÜÍÓ ÁÀÇÓ ÑÊÎϲÞÉÒÅ Â ²ÍØŠ̲ÑÖÅ. rem ÄËß ÀÂÒÎÌÀÒÈ×ÍÎÃÎ ÐÅÇÅÐÂÓÂÀÍÍß ÁÀÇÈ ÏÎÑÒÀÂÒÅ ×ÀÑÎÂÅ ÇÀÂÄÀÍÍß WINDOWS (ÏÀÍÅËÜ ÓÏÐÀÂËÅÍÈÅ - > ÍÀÇÍÀ×ÅÍÍÛÅ ÇÀÄÀÍÈß), rem ÏÎÏÅÐÅÄÍÜΠ²ÄÐÅÄÀÃÓÉÒÅ 32 ÐßÄÎÊ, ÑÏÅÐÅIJ ÏÎÑÒÀÂÒÅ ÑËÎÂÎ rem (ÄËß ÁËÎÊÓÂÀÍÍß Ä²¯ ²ÄÍÎÂËÅÍÍß) pause