What is good practice for checking if a backup completed successfully?
I have come across 3 approaches
1 don't check
2 look in the last line of the backup .sql file
eg -- Dump completed on 2018-08-01 9:43:32
3 check status code 0
What do you recommend and how would you do it in Powershell?