Determine files missed ina backup with ARCserver 11

[cdfKG]

I am attepting to determine if there is a way to easily determine what files are missed in a backup with ARCserver 11. Currenlty, it gives details that says that the job failed, but no details on the individual files that it missed during backup.

On SQL Server, there is a database called 'asdb' with a table called 'asfilename'. Does anyone know if this table or a combination of tables in 'asdb' can be used to determine what files may have been missed in a backup job, or is there another solution? Thanks.

 

[ACiDelic]

The database will only have records of files that were backed up, not ones that were missed.

Try looking at the job log. You will see a list of all the files missed by that job.

 

[cdfKG]

My problem is that I am trying to develop an ASP.NET page that will allow the user to supply a file name, and determine if that file was backed up or missed by executing a query on the SQL data.

It is proving to be a challenge as I do not have any documentation for the ARCserve 11 SQL database and tables. Also, it seems not all of the files are reported as backed up in the 'asdb.asfilename' table if the files are contained within subfolders of a folder that is selected to be backed up. Do you know of any examples or have any suggestions how to get this data from the SQL server?

My query is as follows:
SELECT jobid, comment, path + '\' + filename as [File], filedate as [Last Modified], asjob.starttime as [Last Archived]
FROM astpdat
JOIN astpses on sesid = astpses.id
JOIN asjob on astpses.jobid = asjob.id
JOIN asfilename on asfilename.id = filenameid
JOIN aspathname on aspathname.id = pathid
WHERE jobid = 886