ftp 업로드 배치파일

 @echo off
set YEAR=%date:~2,4%
set MONTH=%date:~7,2%
set DAY=%date:~10,2%
echo open xxx.xxx.xxx.xxx  > MssqlBackuptoFtp.bat
echo user ID PASSWORD >> MssqlBackuptoFtp.bat
echo cd /Backup/Data >> MssqlBackuptoFtp.bat
echo lcd "C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP" >> MssqlBackuptoFtp.bat
echo put BASE_db_%YEAR%%MONTH%%DAY%*.BAK >> MssqlBackuptoFtp.bat
echo close >> MssqlBackuptoFtp.bat
echo quit >> MssqlBackuptoFtp.bat
ftp -i -n -s:MssqlBackuptoFtp.bat
exit



배치파일 스케줄러 등록