BAT UZERINDEN DOSYA + DATABASE YEDEKLEME (EXPRESS ICIN) VE RAR OLARAK TARIH ISMINDE SIKISTIRMA

YEDEK.BAT
---------
@ECHO OFF
set CUR_YYYY=%date:~10,4%
set CUR_MM=%date:~4,2%
set CUR_DD=%date:~7,2%
set CUR_HH=%time:~0,2%
if %CUR_HH% lss 10 (set CUR_HH=0%time:~1,1%)

set CUR_NN=%time:~3,2%
set CUR_SS=%time:~6,2%
set CUR_MS=%time:~9,2%

set SUBFILENAME=%CUR_YYYY%%CUR_MM%%CUR_DD%-%CUR_HH%%CUR_NN%%CUR_SS%

xcopy C:\Users\ek3g\Desktop\*.* D:\veritabanyedekler\yedekleme     /s/d/y/i/h/c/r
sqlcmd -S TURKCELL -i "D:\veritabanyedekler\yedekscript.sql"
"c:\program files\winrar\rar.exe" a -r D:\veritabanyedekler\yedegi_al\%SUBFILENAME% D:\veritabanyedekler\yedekleme\*.*
rd D:\veritabanyedekler\yedekleme\ /s /q




yedekscript.sql
---------------
BACKUP DATABASE [TIGER] TO  DISK = N'D:\veritabanyedekler\yedekleme\TIGER.bak' WITH NOFORMAT, NOINIT,  NAME = N'TIGER-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO