@ECHO OFF

rem nastaveni kam se má záloha uložit
set saveto=D:\PALSTAT3G_DATA\
set moveto=O:\Zaloha_dochazky\
set datenovy=bck
set sql_cmd=C:\Program Files\Microsoft SQL Server\90\Tools\Binn\
set sql_server=ip.or.name.sql.server
set sql_pass=setup.password
set sql_db_data=pal3g_data
set sql_db_archiv=pal3g_archiv
set sql_db_attach=pal3g_attach
set sql_db_qsd=pal3g_qsd




cd %saveto%
mkdir "%saveto%%datenovy%"
del "%saveto%%datenovy%"\*.* /Q /F
echo Vytvořen adresář %saveto%%datenovy% 

echo ZALOHUJI MSSQL DATABAZE PALSTAT
echo -------------------------------
"%sql_cmd%SQLCMD.EXE" -S %sql_server% -U pal -P %sql_pass% -Q "BACKUP DATABASE %sql_db_data% TO DISK = '%saveto%%datenovy%\%sql_db_data%.bak';" >%saveto%%datenovy%\%sql_db_data%.log
"%sql_cmd%SQLCMD.EXE" -S %sql_server% -U pal -P %sql_pass% -Q "BACKUP DATABASE %sql_db_archiv% TO DISK = '%saveto%%datenovy%\%sql_db_archiv%.bak';" > %saveto%%datenovy%\%sql_db_archiv%.log
"%sql_cmd%SQLCMD.EXE" -S %sql_server% -U pal -P %sql_pass% -Q "BACKUP DATABASE %sql_db_attach% TO DISK = '%saveto%%datenovy%\%sql_db_attach%.bak';" > %saveto%%datenovy%\%sql_db_attach%.log
"%sql_cmd%SQLCMD.EXE" -S %sql_server% -U pal -P %sql_pass% -Q "BACKUP DATABASE %sql_db_qsd% TO DISK = '%saveto%%datenovy%\%sql_db_qsd%.bak';" > %saveto%%datenovy%\%sql_db_qsd%.log



echo PRESUN pal3g_data.bak DO %moveto%
move /Y %saveto%%datenovy%\pal3g_data.bak %moveto%

echo -------------------------------
echo PRESUN pal3g_archiv.bak DO %moveto%
move /Y %saveto%%datenovy%\pal3g_archiv.bak %moveto%

echo -------------------------------
echo PRESUN pal3g_qsd.bak DO %moveto%
move /Y %saveto%%datenovy%\pal3g_qsd.bak %moveto%

echo -------------------------------
echo PRESUN pal3g_attach.bak DO %moveto%
move /Y %saveto%%datenovy%\pal3g_attach.bak %moveto%