TimeStamp başka yerden aldım ve editledim: http://stackoverflow.com/questions/19832669/inserting-date-time-stamp-in-file-name-using-bat-script Backup script: http://stackoverflow.com/questions/880487/sql-server-command-line-backup-statement setlocal ENABLEDELAYEDEXPANSION echo off cls echo -- BACKUP DATABASE -- set DATABASENAME=%Evrim_DB :: filename format Name-Date (eg MyDatabase-2009.5.19.bak) ::---------------------------------------------------------- @echo off for /f "tokens=2 delims==" %%a in ('wmic OS Get localdatetime /value') do set "dt=%%a" set "YY=%dt:~2,2%" & set "YYYY=%dt:~0,4%" & set "MM=%dt:~4,2%" & set "DD=%dt:~6,2%" set "HH=%dt:~8,2%" & set "Min=%dt:~10,2%" & set "Sec=%dt:~12,2%" set "fullstamp=%YYYY%_%MM%_%DD%_%HH%%Min%%Sec%" ::%CD% bat dosyasinin bulundugu yerden calistirmaya yarar. set BACKUPFILENAME=%CD%\%DATABASENAME%_backup_%fullstamp%.bak set SERVERNAME=W2012R2SQL.gurmen.local echo. ::sql backup alinir ::-------------------- sqlcmd -E -S %SERVERNAME% -d master -Q "BACKUP DATABASE [%DATABASENAME%] TO DISK = N'%BACKUPFILENAME%' WITH INIT , NOUNLOAD , NAME = N'%DATABASENAME% backup', NOSKIP , STATS = 10, NOFORMAT" :: backup ziplenir ::-------------------------------------------------- 7za a -t7z "%BACKUPFILENAME%.7z" "%BACKUPFILENAME%" -mx5 sleep 10 ::normal backup file silinir. 7z li hali birakilir. ::---------------------------- del "%BACKUPFILENAME%" sleep 10 echo.
