Guest User

Untitled

a guest
Mar 23rd, 2018
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. set NetworkFolder=\192.168.1.1backups
  2. set NetworkFolder2="\192.168.1.1backupsbackup_2018-03-23"
  3.  
  4. echo.
  5. for /f %%a in ('sqlcmd -S %SqlServer% -U %Username% -P %Password% -Q "SET NOCOUNT ON select ltrim(convert(date, getdate()))" -h -1') do set CurrentDate=%%a
  6. echo.
  7.  
  8. echo.
  9. set NetworkFolder2="%NetworkFolder%backup_%CurrentDate%"
  10. echo.
  11.  
  12. IF exist %NetworkFolder2%( xcopy "%LocalFolder%*.*" "%NetworkFolder%backup_%CurrentDate%_Latest" /s/h/e/k/f/c && echo %NetworkFolder_% exists ) ELSE ( xcopy "%LocalFolder%*.*" "%NetworkFolder%backup_%CurrentDate%" /s/h/e/k/f/c && echo %NetworkFolder_% dont exists)
Add Comment
Please, Sign In to add comment