![]() ![]() status will be populated only after the backup completes (otherwise null) example of conditional test using backup type and stage note that the backup extract backup type, stage, and status into variables Using the example variable declaration above, let's look at an example of how you might extract and use this information (see inline comments for details). Your custom script can extract information from the above declaration by using SQL Server's built-in XML querying capabilities. Status: "Finished", "FinishedWithErrors", "Cancelled" or "Failed" Stages: "BeforeBackup" or "AfterBackup" SQL Backup Master declares an XML variable prior to executing your SQL script, thereby making backup job state information available to your script at run time. Such errors will not halt the progress of the backup job. ![]() a set of custom SQL statements) before and after the associated backup job is executed.Įrror and informational messages that occur during custom SQL script execution are written to the SQL Backup Master log. SQL Backup Master offers the ability to execute a custom SQL script (e.g.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |