Hello. The problem is as follows. SQL Express 2008 R2,
backup is made by the means of bat file and sp. Need to have a table that would
hold columns like 'date_of_backup', 'duration', 'message' (the one that appears
on 'messages' tab in the result area after backup completion/failure). Didn't
manage to find sufficient info on this topic. Please, help me resolve this
issue. I will be very grateful for assistance. This is an example of real
message that I want to catch:
Server: Msg 911, Level 16, State 11, Line 1
Database 'not_existing_db' does not exist. Make sure that the name is
entered correctly.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP
DATABASE is terminating abnormally.
Go to the complete details ...