Example of a failure report?

Aug 25, 2009 at 8:37 PM

I'd like to set up a VBscript or something to parse the report files created by expressmaint so that it can email me about failures. What should I be looking for in the text files to indicate that a problem has occurred? My test backup completed successfully, and I don't see any place on the site where this is documented


Aug 25, 2009 at 9:17 PM

The easisest is probably to check the return code from the executable. The following post lists the possible return codes http://sqlblogcasts.com/blogs/sqldbatips/archive/2009/08/08/expressmaint-return-codes.aspx and this one shows how to trap this in a batch file http://sqlblogcasts.com/blogs/sqldbatips/archive/2007/11/28/how-to-backup-a-database-only-it-passes-an-integrity-check-using-expressmaint.aspx

Aug 26, 2009 at 12:57 PM

You are a gentleman and a scholar.