DosTips.com

Hi, Got it, can I get the result in MB's? It's giving me blank value using the below one. :next ::get DB size set targetDBSize= for %%i in ("\\SERVER_NAME\c$\Progra~1\Micros~1\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\%targetSite%.mdf") do set /A targetDBSize=%%~zi/1024/1024 echo %targetDBSize% >>...

Hi,
But if the file size is more than 2GB, it is not showing any result.

-Kalyan

Hi, I wrote a script which will get the file size and dump to a CSV. Below is the script: ::get DB size set targetDBSize= for /F "tokens=1 " %%i in ('du -m \\servername\c$\Progra~1\Micros~1\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\%targetSite%.mdf') do set targetDBSize=%%i echo %targetServer%,%ta...