Mark,

It is probably time to initiate a call with IBM support.
We need to get some traces and logs to further diagnose.

A few other thoughts I had before you call support...

* I am assuming this is a restore of a FULL backup.
   If it is an incremental restore, the associated prior
   full and prior incremental(s) must be applied first.

* This isn't the master,  msdb, or temp database, is it?
    These databases have special needs.

* The prior "ANS0322E (RC306)" message is also bothering me.
    Check DSIERROR.LOG file (normally in the "agentsql" directory).
   There may have been a problem getting the backup object from the
   ADSM server for some reason.
   Do you have the "Wait for Tape Mounts" options checked?
   Is the object on tape?

Del Hoobler
ADSM Agent Development
IBM Corporation

>> Del,
>>
>> The restore I am attempting is for a single object. The SQL error log
>> doesn't seem to register any error messages. According to the SQL admin
>> the messages in that log are normal startup messages for the SQL
>> machine. I am not very versed in SQL so I have to take his word for it.
>> I can't export the SQL log to send a copy. Any more ideas?
>>
>> -----------------------------------------------
>> Mark L. Evans - MCSE
>> mevans AT co.slc.ut DOT us
>> Network Administrator
>> Salt Lake County Information Services
>> -----------------------------------------------
>> Colorado Railroad and Mining History
>> at: http://www.narrowgauge.org/
>> -----------------------------------------------