One way to do this is to perform a restore and redirect
the files and database into a separate name and location.
For example:

   tdpsqlc restore db1 full /into=dmtemp /relocatedir=d:\dbtemp
/recovery=no

When this is done... you have the .MDF and .LDF files.

Thanks,

Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 06/16/2010
02:38:51 PM:

> [image removed]
>
> DP for DB's: SQL Restore question
>
> Rick Adamson
>
> to:
>
> ADSM-L
>
> 06/16/2010 02:39 PM
>
> Sent by:
>
> "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
> Please respond to "ADSM: Dist Stor Manager"
>
> I have been asked many times to restore databases from TSM to flat
> files, and not attach them to the SQL Server. I have tried to use the
> "Restore Groups/Files option" but when I open the SQL Mngmt Studio, it
> shows the database with a status of "restoring". Have also tried not
> using the recovery option, but the DBA's claim that this does not simply
> dump the files from TSM. Can someone tell me how to accomplish this or
> point me towards the doco? I have been all through the DP for DB's user
> guide and have not found anywhere where it explicitly states this is
> possible. What am I doing wrong?
>
>
>
> All comments appreciated.
>
>
>
> DP 4 DB's              5.5.4.0
>
> TSM Server         5.4.5.2
>
>
>
> ~Rick