1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
@echo off
echo -------------------------------------------------------
echo This script will create a backup of the database FB...
echo author : Sofien HAMMAMI
echo -------------------------------------------------------
echo setting up files names values...
echo -------------------------------------------------------
set fic_sauv=sauvegarde__%date:~0,2%_%date:~3,2%_%date:~6,4%__%time:~0,2%!%time:~3,2%!%time:~6,2%.dmp
set dir_sauv=sauvegarde__%date:~0,2%_%date:~3,2%_%date:~6,4%
set log_sauv=log__%date:~0,2%_%date:~3,2%_%date:~6,4%__%time:~0,2%!%time:~3,2%!%time:~6,2%.log
set racine_sauv = E:\
echo Files names values are assigned...
echo -------------------------------------------------------
echo *******************************************************************************
echo **************************** Starting .... ************************************
echo *******************************************************************************
IF NOT EXIST %racine_sauv%essais\%dir_sauv% mkdir %racine_sauv%essais\%dir_sauv%
exp80 <user_name>/<mp>@<db_name> owner=<user_name>file=%racine_sauv%essais\%dir_sauv%\%fic_sauv% log=%racine_sauv%essais\%dir_sauv%\%log_sauv%
echo *******************************************************************************
echo ******************************* End ! *****************************************
echo *******************************************************************************
pause |
Partager