Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.
DECLARE @kill as varchar(100), @body as varchar(5000), @AlertSummary as varchar(1200), @Timestamp as varchar(1200), @Instance as varchar(1200) set @kill = @kill + 'kill ' + SUBSTRING( $(AlertSummary) , 11, CHARINDEX(' ', $(AlertSummary) ,12) -11); set @body = cast(@kill as varchar(15)) + '; ' + 'A SQL process with '+ $(AlertSummary) + ' at ' + $(Timestamp) + ' on ' + $(Instance) + '. ' +' As the tempdb storage it used has reached a limit, this SQL query has been killed'; EXEC msdb.dbo.sp_send_dbmail @profile_name = 'noreply', @recipients = '<email>', @body = @body, @subject = 'Testing: A SQL query using too much tempdb database has been killed'
$(Timestamp), $(Metric) on $(Instance) is $(Severity). $(AlertText) $(Metric): $(Description)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.