If dsmc restore is timing out, SQL is likely to be even worse. I would try
a QUERY BACKUP with dsmc (I've never seen that time out, even when restore
is), then create some lists for a -filelist restore.

On Tue, Jun 09, 2015 at 03:58:36PM +0000, Lee, Gary wrote:
> We have a restore request which has so many files an dsubdirectories that the 
> client is timing out before restoration can start.
>
> Can anyone help with a sql query which will get me a list of all next level 
> subdirectories under the master directory?
>
> All objects will be inactive, as the originals were deleted immediately after 
> backup.
> Something like
> Select name where node_name=xx and hl_name=yy
>
> Tried this and got nothing, I know there are hundreds there.
>
> Thanks for any assistance.

--
-- Skylar Thompson (skylar2 AT u.washington DOT edu)
-- Genome Sciences Department, System Administrator
-- Foege Building S046, (206)-685-7354
-- University of Washington School of Medicine