Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.
Help with batch file that compares file size to available space
I need a batch file created that can replace a broken backup feature of an old program. I need the batch file to look at the size of the file that will be backed up, compare it to the available space on the F: drive. If there is space, then it copies the file, if there isn't space, then it deletes the oldest file in the destination to make room for a new file.
Basically, I'm backing up one file, once per day, and just need to make sure that that the drive has space before copying. My current batch file is:
@echo off
set mydate=%date:~4,2%_%date:~
copy /z "C:\Program Files (x86)\Camelot3\Database\CA
This is just so that I can keep multiple copies of this file
Basically, I'm backing up one file, once per day, and just need to make sure that that the drive has space before copying. My current batch file is:
@echo off
set mydate=%date:~4,2%_%date:~
copy /z "C:\Program Files (x86)\Camelot3\Database\CA
This is just so that I can keep multiple copies of this file
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
I wear a lot of hats...
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
This file is slightly smaller than 1GB, the destination is a 16GB flash drive. The only thing in the Camelot folder on the flash drive is this backup. If I can keep the last 10 days worth of backups, that would be great.
I haven't tested this here, so don't test it immediately against useful data just in case...
I added comments, hopefully it makes sense, take a look, and think about what's going on to double check my thought process.
You might want to add some ECHO statements along the way and PAUSE a few times to make sure the variables are being set as expected, and the flow is as expected.
»bp
I added comments, hopefully it makes sense, take a look, and think about what's going on to double check my thought process.
You might want to add some ECHO statements along the way and PAUSE a few times to make sure the variables are being set as expected, and the flow is as expected.
@echo off
setlocal EnableDelayedExpansion
rem Build date string for new backup copy
set MyDate=%DATE:~4,2%_%DATE:~7,2%_%DATE:~10,4%
rem Define source and destination paths
set BaseDir=C:\Program Files (x86)\Camelot3\Database
set DestDir=F:\Camelot
set BaseFile=%BaseDir%\CAMDB.FDB
set DestFile=%DestDir%\Camdb_%MyDate%.fdb
rem Make sure the file to backup exists
if not exist "%BaseFile%" (
echo *ERROR* database file to backup does not exist
exit /b
)
rem Make sure the dest folder exists, create it if needed
if not exist "%DestDir%" (
mkdir "%DestDir%"
)
rem Get size (in bytes) of current file, left pad to build 16 byte string of size
for %%A in ("%BaseFile%") do set BaseSize=%%~zA
set BaseSize=0000000000000000%BaseSize%
set BaseSize=%BaseSize:~-16%
:CheckSpace
rem Get free space (in bytes) of dest drive, left pad to build 16 byte string of size
for /f "tokens=3" %%A in ('dir "%DestDir%"\^|find /i "bytes free"') do set "DestFree=%%A"
set DestFree=0000000000000000%DestFree%
set DestFree=%DestFree:~-16%
rem If this file won't fit, try to delete oldest backup
if "%BaseSize%" GTR "%DestFree%" (
rem Doesn't fit, look for oldest file to delete
set DeleteFile=
for /f "tokens=*" %%A ('dir /a-d /b /o-d "%DestDir%"') do set DeleteFile=%DestDir%\%%~A
rem If no files to delete in destination folder error out
if not defined DeleteFile (
echo *ERROR* No room for backup copy on destination drive, quiting
exit /b
)
rem Delete oldest file, check if it fits now
del "!DeleteFile!" >NUL
goto :CheckSpace
)
rem Since it should fit, copy it now
copy /z "%BaseFile%" "%DestFile%"
»bp
Experts Exchange Solution brought to you by
Your issues matter to us.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day free trial
I tested on the backup test server i created during this super long recovery I've been doing. I've attached the error I'm getting.
BTW, Thanks so much.
BatchCapture.JPG
BTW, Thanks so much.
BatchCapture.JPG
Looks like I made a typo, change:
for /f "tokens=*" %%A ('dir /a-d /b /o-d "%DestDir%"') do set DeleteFile=%DestDir%\%%~A
to:
for /f "tokens=*" %%A in ('dir /a-d /b /o-d "%DestDir%"') do set DeleteFile=%DestDir%\%%~A
»bp
for /f "tokens=*" %%A ('dir /a-d /b /o-d "%DestDir%"') do set DeleteFile=%DestDir%\%%~A
to:
for /f "tokens=*" %%A in ('dir /a-d /b /o-d "%DestDir%"') do set DeleteFile=%DestDir%\%%~A
»bp
YOU ARE THE MAN!!! You are my savior!
Under normal circumstances, I usually could come up with something that accomplished this job in a far less elegant way. But, after staying up all night, recovering this clients haphazardly assembled server, only to find that the backup they've been doing didn't even contain the most important data, and then breaking my glasses while trying to make this batch file, I was ready to give up and call an Uber home (because I can't drive without my glasses).
Under normal circumstances, I usually could come up with something that accomplished this job in a far less elegant way. But, after staying up all night, recovering this clients haphazardly assembled server, only to find that the backup they've been doing didn't even contain the most important data, and then breaking my glasses while trying to make this batch file, I was ready to give up and call an Uber home (because I can't drive without my glasses).
Turns out that I celebrated too soon. I forgot to make sure that it deleted the oldest file if the drive was full. That part doesn't work.
Sorry, was away on holiday, and then took ill for a bit, do you still need additional help with this? If so can you post some additional info about the test you did, the setup for it, the results, and what your expected results were please.
»bp
»bp
Okay, made several adjustments, see if this deletes older file(s).
»bp
@echo off
setlocal EnableDelayedExpansion
rem Build date string for new backup copy
set MyDate=%DATE:~4,2%_%DATE:~7,2%_%DATE:~10,4%
rem Define source and destination paths
set BaseDir=C:\Program Files (x86)\Camelot3\Database
set DestDir=F:\Camelot
set BaseFile=%BaseDir%\CAMDB.FDB
set DestFile=%DestDir%\Camdb_%MyDate%.fdb
rem Make sure the file to backup exists
if not exist "%BaseFile%" (
echo *ERROR* database file to backup does not exist
exit /b
)
rem Make sure the dest folder exists, create it if needed
if not exist "%DestDir%" (
mkdir "%DestDir%"
)
rem Get size (in bytes) of current file, left pad to build 16 byte string of size
for %%A in ("%BaseFile%") do set BaseSize=%%~zA
set BaseSize=0000000000000000%BaseSize%
set BaseSize=%BaseSize:~-16%
:CheckSpace
rem Get free space (in bytes) of dest drive, left pad to build 16 byte string of size
for /f "tokens=3" %%A in ('dir "%DestDir%"\^|find /i "bytes free"') do set "DestFree=%%A"
set DestFree=!DestFree:,=!
set DestFree=0000000000000000!DestFree!
set DestFree=!DestFree:~-16!
rem If this file won't fit, try to delete oldest backup
if "%BaseSize%" GTR "!DestFree!" (
rem Doesn't fit, look for oldest file to delete
set DeleteFile=
for /f "tokens=*" %%A in ('dir /a-d /b /o-d "%DestDir%"') do set DeleteFile=%DestDir%\%%~A
rem If no files to delete in destination folder error out
if not defined DeleteFile (
echo *ERROR* No room for backup copy on destination drive, quiting
exit /b
)
rem Delete oldest file, check if it fits now
del "!DeleteFile!" >NUL
goto :CheckSpace
)
rem Since it should fit, copy it now
copy /z "%BaseFile%" "%DestFile%"
»bp
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Batch
From novice to tech pro — start learning today.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
How large is the target drive?
How large (in bytes) are the files being backed up?
What if removing the oldest file doesn't result in enough space, should the next oldest also be removed, etc?
When finding the oldest file, is it true that all files in the folder need to be looked at, or only a certain filter of them (like *.FDB)?
»bp