Bo, Take a look at this: http://www-1.ibm.com/support/docview.wss?uid=swg21289895
If you are using Data Protection for SQL 5.5, you should also look at the new RELOCATEDIR option: http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp?topic=/com.ibm.itsmfd.doc/dpsql.htm Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 07/02/2008 08:46:56 AM: > I want to restore more than 100 DB's to a another server. > > And I don't want to define all the new DATA and LOG files, before > restoring. > > I have found this command: tdpsqlc res ApplinX full > /Fromsqlserver=cdkalb008 /to="F:\MSSQL$DEMO3\Data\" /relocate /create > > I get this error msg.: [Microsoft][ODBC SQL Server Driver][SQL > Server]Device activation error. The phyical file name > 'F:\MSSQL\DATA\ApplinX_Data.MDF' may be incorrect. > > It is not the path that I want to restore to. > > So is there a command to do the restore?