ͨ¹ýÅú´¦Àí£¬ÊµÏÖSQL ServerÊý¾Ý¿â¶¨ÆÚ±¸·Ýµ½ftp

@echo off
rem --------------------- ÅäÖÃ: ftpÉÏ´«²ÎÊý,¼°±¾µØÎļþĿ¼(Êý¾Ý¿â±¸·ÝµÄÁÙʱĿ¼)-----------------
set "PUT_FTP_SERVER=192.168.1.100"
set "PUT_FTP_PORT=21"
set "PUT_FTP_USERNAME=ftpuser"
set "PUT_FTP_PASSWORD=ftppasswd"
set "PUT_DIR=/"
set "LOCAL_DIR=D:\sql_dbbackup\"
rem ----------------------³ÌÐò¿ªÊ¼-----------------------------------------------------------------------
echo begin_backup_db
rem µ÷ÓÃÊý¾Ý¿â±¸·Ý´æ´¢¹ý³Ì,²ÎÊýΪ±¾µØĿ¼. Êý¾Ý¿â·µ»Ø"¹ýÆÚÐèҪɾ³ýµÄ±¸·ÝÎļþ"
sqlcmd -E -S 127.0.0.1,1333 -d master -v BAK_PATH="'%LOCAL_DIR%'" -Q "execute dbo.p_job_backup $(BAK_PATH);" -t 4800 -h -1 -W | findstr bak>>del_file.txt
rem ¿ªÊ¼×Ô¶¯ÉÏ´«(ÉÏ´«Íêɾ³ý¶ÔÓ¦µÄ±¾µØÎļþ)
echo begin_ftp_upload
call :uploaddir "%LOCAL_DIR%" "%PUT_DIR%"
rem ¼ì²éÊÇ·ñÉÏ´«Ê§°Ü,ʧ°ÜÔò¼Ç¼Êý¾Ý¿âÈÕÖ¾
echo begin_check
for /f "delims=" %%i in ('dir /b /a-d "%LOCAL_DIR%*.bak"') do echo %%~nxi>>local_file.txt
if not exist local_file.txt goto :delete_remote
for /f "delims=" %%i in (local_file.txt) do (
sqlcmd -E -S 127.0.0.1,1333 -d master -v FILE_NAME="'%%i'" -Q "insert into t_log_backup(loglevel, filename, remark) values(1,$(FILE_NAME),'ÑÏÖØ´íÎó:ÉÏ´«±¸·ÝÎļþʧ°Ü,Çë¼ì²éftpȨÏÞ.ͬʱËü»áµ¼Ö±¾µØ´ÅÅÌÂú.');" -t 3600
)
del /f/q local_file.txt
rem ¿ªÊ¼É¾³ýÔ¶³Ì¹ýÆÚÎļþ
echo begin_del_remote
:delete_remote
call :delremotefile "%LOCAL_DIR%" "%PUT_DIR%"
rem Æô¶¯Êý¾Ý¿â·¢ËÍÓʼþ(¼´·¢ËÍ´íÎóÈÕÖ¾)
sqlcmd -E -S 127.0.0.1,1333 -d master -Q "execute dbo.p_sendmail;" -t 120
echo end.
goto :eof
rem ---------------------³ÌÐò½áÊø-------------------------------------------------------------------------
rem ---------------------ÒÔϾùΪµ÷ÓõÄ×Óº¯Êý-------------------------------------------------------------
:uploaddir - upload directory tree
::         - %~1 local directory
::         - %~2 remote directory
setlocal
set "localdir=%~1"
set "remotedir=%~2"
call :put_autoftp cmdftp_uploaddir "