備份首旺資料庫

利用 Windows 排程執行器執行功能

利用排程執行 bat Script 來備份資料庫報網芳資料庫，
並執行比對，只列出最新檔案來傳送

net use 掛載網芳資料夾， 若已掛載，則刪除並離開

@echo off
cls
rem NET COMPUTER \\dxbtest /ADD
net use z: \\file-server2\sowon && (net use v: /delete /Y || exit /b 1)

rem copy "z:\FolderName" "D:\MSSQL\BAK\"

FOR /F "eol=| delims=" %%I IN ('DIR "D:\MSSQL\BAK\ACC" /A-D /B /O-D /TW 2^>nul') DO (
    SET ACCFile=%%I
    GOTO FoundACC
)
rem ECHO No  file found!
GOTO :EMP

:FoundACC
rem ECHO "D:\MSSQL\BAK\ACC\%ACCFile%" "z:\ACC"
copy /B /V /Y "D:\MSSQL\BAK\ACC\%ACCFile%" "z:\ACC"
GOTO :EMP


:EMP
FOR /F "eol=| delims=" %%I IN ('DIR "D:\MSSQL\BAK\EMP" /A-D /B /O-D /TW 2^>nul') DO (
    SET EMPFile=%%I
    GOTO FoundEMP
)
rem ECHO No  file found!
GOTO :FJW

:FoundEMP
rem ECHO "D:\MSSQL\BAK\ACC\%EMPFile%" "z:\EMP"
copy /B /V /Y "D:\MSSQL\BAK\EMP\%EMPFile%" "z:\EMP"
GOTO :FJW


:FJW
FOR /F "eol=| delims=" %%I IN ('DIR "D:\MSSQL\BAK\FJW" /A-D /B /O-D /TW 2^>nul') DO (
    SET FJWFile=%%I
    GOTO FoundFJW
)
rem ECHO No  file found!
GOTO :EOF

:FoundFJW
ECHO "D:\MSSQL\BAK\ACC\%FJWFile%" "z:\FJW"
copy /B /V /Y "D:\MSSQL\BAK\FJW\%FJWFile%" "z:\FJW"

GOTO :EOF