Re: select statement for active files/client/tape

2003-06-28 Thread Stapleton, Mark
From: Joni Moyer [mailto:[EMAIL PROTECTED] I am going to a disaster recovery shortly and I have the users asking if there is any select statement or method to find all active files, what tapes these files are on and the order that they are on the tape for each client for the offsite tape

select statement for active files/client/tape

2003-06-24 Thread Joni Moyer
Hi all SQL gurus! I am going to a disaster recovery shortly and I have the users asking if there is any select statement or method to find all active files, what tapes these files are on and the order that they are on the tape for each client for the offsite tape copies. Is this possible? And

Re: select statement for active files/client/tape

2003-06-24 Thread Richard Sims
I am going to a disaster recovery shortly and I have the users asking if there is any select statement or method to find all active files, what tapes these files are on and the order that they are on the tape for each client for the offsite tape copies. Is this possible? And if so, how intensive