• Hi...You can try below cmd:

    --To Restore db backup to different (existing db2 on sever2) database on different server.

    Below example shows the restore of DB1 backup taken on SERVER1 and restored in DB2 on SERVER2.In this case TSM.OPT file enrty needs to point to SERVER1.

    d:\tsm\tdpsql\tdpsqlc restore DB1 full /into=DB2  /fromsqlserver=SERVER1 /recovery=yes /replace

    /relocate=DB1d1Data  /to=E:\MSSQL2000 MSSQL\data\DB2_Data.MDF /relocate=DB1L1Log  /to=G:\MSSQL2000\MSSQL\Log\DB2_Log.LDF /relocate=DB1d2Data /to=E:\MSSQL2000\MSSQL\data\DB2_Data2.NDF /relocate=DB1d3Data /to=E:\MSSQL2000\MSSQL\data\DB2_Data3.NDF /relocate=DB1d4Data /to=E:\MSSQL2000\MSSQL\data\DB2_Data4.NDF

    You can execute below cmd for full syntax help.

    tdpsqlc help rest full

    --JP