共享腳本壓縮sql數據庫后上傳到ftp最后由 qwertl 于 -11-25 11:25win2003+mssql server)壓縮sql數據庫后上傳到ftp：在論壇學習到的,給有用得著的參考下。 代碼如下：net stopSQLSERVERAGENTping -n 10 127.1>nulnet stop MSSQLSERVERping -n 10 127.1>nulC:Program Files7-Zip7z.exe a -p111222 d:rardatasql1_%date:~0,4%%date:~5,2%%date:~8,2%_%time:~0,2%%time:~3,2%.7z d:sqldatasql1*.*C:Program Files7-Zip7z.exe a -p111222 d:rardatasql2_%date:~0,4%%date:~5,2%%date:~8,2%_%time:~0,2%%time:~3,2%.7z d:sqldatasql2.mdf d:sqldatasql2_log.ldfping -n 10 127.1>nulnet start MSSQLSERVERping -n 10 127.1>nulnet start SQLSERVERAGENTd:softwareautodel 60 d:rardataset desfolder=d:rardatadir %desfolder% /b /aa-d>nul 2>nulif %errorlevel% equ 1 (echo No archiving file to FTPping -n 10 127.1>nulgoto :eof)set FtpFile=%temp%TempAcc.txt>%FtpFile% echo account>>%FtpFile% echo pwd>>%FtpFile% echo cd subdir>>%FtpFile% echo binfor /f tokens=* %%a in ('dir %desfolder% /b /aa-d') do (>>%FtpFile% echo put %desfolder%%%a)>>%FtpFile% echo byeecho. >>d:softwarearlog.txtecho sql包上傳ftp時間:%date% %time%>>d:softwarearlog.txtftp -v -i -s:%FtpFile% ftpSRV_IP>>d:softwarearlog.txtecho. >>d:softarlog.txttime /t >>d:softwarearlog.txtecho sql壓縮包數據上傳FTP完成== >>d:softwarearlog.txtecho. >>d:softwarearlog.txtecho. >>d:softwarearlog.txtping -n 2 127.1>nulattrib -a %desfolder%*.*ping -n 6 127.1>nuldelete %temp%TempAcc.txtexit