Create a bat file call “testDatabase.bat”, mine is in c:\backup
Code: Select all
@Echo Off sqlcmd -U Veeam_Lab_user -P Password -S %1 -d %2 -Q "quit" >>sqllog.txt rem Using SQL Authentication, create SQL with denied read denied write to all databases rem results append to log sqllog.txt rem sqlcmd -S %1 -d %2 -Q "quit">>sqllog.txt REM using Windows Authentication rem sqlcmd -S GR-VEEAM\VEEAM -E -d "veeamBackup" -Q "quit" >>sqllog.txt rem pass server/instance if not errorlevel 1 goto next1 echo SQLCMD returned %errorlevel% to the command shell echo == An error occurred goto theend :next1 echo Found Database exit /B 0 :theend exit /B 1 REM use below to test and see error code - place in it owns bat file. REM call testdatabase.bat /Z REM echo %ERRORLEVEL% REM IF ERRORLEVEL 1 echo "Error"
Name: Databasetotest (using the name helps reading the reports and real time logs)
Arguments: %vm_ip% databasename
Repeat group for each database name
Veeam thinks you could do to make better
1) Allow edit of predefined tests arguments, was easy to make this as a pull down but couldn’t edit arguments ( database name )
2) Some way to write results to the Veeam log, this way I could include database size, record count or what ever.
3) Just place in next version.
Hope you enjoy. now I am real sure all my database backups worked, I use this live with no issues with a TB of info.