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 (skyl...@u.washington.edu) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354 -- University of Washington School of Medicine
