The SureBackup job aggregates all settings and policies of the recovery verification task, such as application group and Virtual Lab to be used, VM backups that must be verified in the virtual lab and so on. This feature is not a SureBackup job! A SureBackup job is an automated task for recovery verification by starting the Virtual Machines from the backup file. You can easily check your backup files with a command line tool located into the installation folder of the software: (path: C:\Program Files\Veeam\Backup and Replication\Backup). $elapsed = (($endt - $begint).Veeam Backup Validator is an unknown feature that allows checking the consistency of a backup created with Veeam Backup and Replication. # - Figure out how many time the script take to run $MyReport += HTMLTab-red $srv.Object_Name $srv.reason $MyReport += HTMLTab-Yellow $srv.Object_Name $srv.reason $MyReport += HTMLTab-Green $srv.Object_Name $VMStatus = Invoke-Sqlcmd2 $mySQLInstance $mySQLDatabase $mySQLQuery session_id = " + "'" + $VeeamSessionId.id + "' AND.
# Run query including job id and session id $VeeamSessionId = Invoke-Sqlcmd2 $mySQLInstance $mySQLDatabase $mySQLQuery $mySQLQuery = "select id FROM where end_time = (select MAX(end_time) FROM WHERE job_id = " + "'" + $VeeamJobId.id + "') AND job_id = " + "'" + $VeeamJobId.id + "'" $VeeamJobId = Invoke-Sqlcmd2 $mySQLInstance $mySQLDatabase $mySQLQuery $mySQLQuery = "select id, name from where name = " + "'" + $VeeamJob + "'" $VeeamJobList = "My First Veeam Job","My Second Veeam Job", "My Third Veeam Job" $mySQLInstance = "VeeamServer\VEEAM_INST" # Assuming that we work with the same SQL Server instance and the same database, let's initiate this parameters $Report = $($myServer) $($myStatus) $Reportįunction HTMLTab-Yellow ($myServer,$myStatus)įunction HTMLTab-Red ($myServer,$myStatus) # - HTMLTab-Red : Add a Red cell to tab (for Failed Status)įunction HTMLTab-Green ($myServer,$myStatus) # - HTMLTab-Yellow : Add a Yellow cell to tab (for Warning Status) # - HTMLTab-Green : Add a Green cell to tab (for Success Status) $conn.ConnectionString="Server= Integrated Security=True" -f $ServerInstance,$Database # This function run a SQL query with 3 main parameters # Adapted version of the function found on the web site # This script run SQL queries on Veeam SQL database in order to create a Veeam per-VM report # Yannick Levadoux Created on May 4th, 2011
0 kommentar(er)
