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@vm.marist.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@vm.marist.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
