> I am having trouble using GUI TDP for SQL.  Sometimes, not always, I get
a
> message saying "Waiting for SQL server" when trying to restore fulls with
> incrementals.  Some incrementals go on just fine, but others hang.  The
> screen will stay there forever until I end the task from task manager.
The
> session on the TSM server is in a IDLEW condition and the activity log on
> the TSM server says it has started the incremental restore.
>
> Has anyone seen this before?

Rob,

I have seen this before when an allocated size of a database is large
but the actual database contents are small.  And so what happens,
is that when TDP for SQL is done "restoring" the data, the SQL server
itself still needs to go through and "rebuild/format" the remaining
pages of the allocated database... and for largely allocated databases,
this could take a while. I suggest that when this occurs, you look
at the SQL Server log to see what the SQL Server thinks is going on.
Other than that, you may want to open a PMR so that Level 2
can gather trace information to find out where the hang really is.

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

"It's a beautiful day.  Don't let it get away."  -- Bono