How do I write a Windows batch script to copy the newest file from a directory?

by

The accepted answer gives an example of using the newest file in a command and then exiting. If you need to do this in a bat file with other complex operations you can use the following to store the file name of the newest file in a variable:

FOR /F "delims=" %%I IN ('DIR "*.*" /A-D /B /O:D') DO SET "NewestFile=%%I"

Now you can reference %NewestFile% throughout the rest of your bat file.

For example here is what we use to get the latest version of a database .bak file from a directory, copy it to a server, and then restore the db:

:Variables
SET DatabaseBackupPath=\\virtualserver1\Database Backups

echo.
echo Restore WebServer Database
FOR /F "delims=|" %%I IN ('DIR "%DatabaseBackupPath%\WebServer\*.bak" /B /O:D') DO SET NewestFile=%%I
copy "%DatabaseBackupPath%\WebServer\%NewestFile%" "D:\"

sqlcmd -U <username> -P <password> -d master -Q ^
"RESTORE DATABASE [ExampleDatabaseName] ^
FROM  DISK = N'D:\%NewestFile%' ^
WITH  FILE = 1,  ^
MOVE N'Example_CS' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Example.mdf',  ^
MOVE N'Example_CS_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Example_1.LDF',  ^
NOUNLOAD,  STATS = 10"

More Related Contents:

  1. Progress bar shows "echo is OFF" message
  2. Why is no string output with ‘echo %var%’ after using ‘set var = text’ command in cmd? [duplicate]
  3. Where does GOTO :EOF return to?
  4. How to set environment variables with spaces?
  5. Split long commands in multiple lines through Windows batch file
  6. Assign command output to variable in batch file
  7. Why are other folder paths also added to system PATH with SetX and not only the specified folder path?
  8. Can I mask an input text in a bat file?
  9. Logical operators (“and”, “or”) in DOS batch
  10. How do you loop in a Windows batch file?
  11. How do I make a batch file terminate upon encountering an error?
  12. Get size of a directory in ‘MB’ using batch file
  13. BAT file: Open new cmd window and execute a command in there
  14. Set output of a command as a variable (with pipes) [duplicate]
  15. batch file – counting number of files in folder and storing in a variable
  16. Drag and drop batch file for multiple files?
  17. Batch / Find And Edit Lines in TXT file
  18. ERRORLEVEL inside IF
  19. How to write a full path in a batch file having a folder name with space?
  20. Waiting for parallel batch scripts
  21. Why does ‘Run as administrator’ change (sometimes) batch file’s current directory?
  22. windows batch files: setting variable in for loop
  23. batch echo pipe symbol causing unexpected behaviour
  24. How can I escape an exclamation mark ! in cmd scripts?
  25. How to set a timeout for a process under Windows 7?
  26. Batch – Converting variable to uppercase
  27. Batch rename sequential files by padding with zeroes
  28. How to loop through comma separated string in batch?
  29. Batch File To Play A Song
  30. To “Call” or “Not to Call” a batch file?

Leave a Comment