Steve,

Make sure you have level 1.1.1 of the SQL Agent.
(1.1.1 is PTF #1, i.e. IP21419.)

Try clicking on the "Direct Query" button on the
Restore tab.  Did you see it there?

Try "SQLDSMC /ADSMQUERYDB".  How about now?
Or better yet... "SQLDSMC /ADSMQUERYDB:dbname"
(to just query for the database in question.)

Try backing the database up interactively with the
SQL Agent GUI and/or the SQL Agent command-line.
It is successful?

Does the database name have any "non-standard"
characters that might confuse the query engine?

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM ADSM Agent Development
hoobler AT us.ibm DOT com


====================================================

>

Where is my SQL Agent backup ?
> Has anyone encountered a problem like this ?
> I backup 8 SQL databases with a schedule which
> Executes a command to start the backup.
> My log indicates a successful backup on the database in question and
> The SQL event log says the backup and schedule completed successfully.
> If I start my SQL Agent GUI on the NT server, click on restore, then
> Click on refresh to see the list of backups, the backup does not exist.
> All other database backups are there.
>