I don't work with the TDP for SQL, but one thing caught my eye:

Do you really need to repeat the /RELOCATE term twice? If your command is being 
truncated because it's too long, what happens if you leave out the second 
/RELOCATE term? 

On Feb 3, 2013, at 2:08 PM, felymich <tsm-forum AT BACKUPCENTRAL DOT COM> wrote:

> Hello,
> 
> Thanks for the answer.
> C:\Program Files\Tivoli\TSM\TDPSql>TDPSQLC RESTORE WSS_Team_Content 
> /RELOCATE=WS
> S_Team_Content /to="E:\Program Files\Microsoft SQL 
> Server\MSSQL10.MSSQLSERVER\MS
> SQL\DATA\WSS_Team_Content.mdf" /RELOCATE=WSS_Team_Content_Log /to="E:\Program 
> Fi
> les\Microsoft SQL 
> Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\WSS_Team_Content_log.ldf
> " /FROMSQLServer=MBSQLSPCL-ENT /TSMOPTFile=dsm_MBSQLSPCL.opt 
> /Stopat=01/30/2013
> 
> IBM Tivoli Storage Manager for Databases:
> Data Protection for Microsoft SQL Server
> Version 5, Release 5, Level 5.0
> (C) Copyright IBM Corporation 1997, 2010. All rights reserved.
> 
> ACO0103E Invalid option for the specified command: RESTORE WSS_Team_Content 
> /REL
> OCATE=WSS_Team_Content /to=E:\Program Files\Microsoft SQL 
> Server\MSSQL10.MSSQLSE
> RVER\MSSQL\DATA\WSS_Team_Content.mdf /RELOCATE=WSS_Team_Content_Log 
> /to=E:\Progr
> am Files\Microsoft SQL 
> Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\WSS_Team_Content_lo
> g.ldf /FROMSQLServer=MBSQLSPCL-ENT /TSMOPTFile=dsm_MBSQLSPCL.opt /Stopat
> 
> the truncation is still here and the command failed again...
> 
> Thanks,
> Dom
> 
> +----------------------------------------------------------------------
> |This was sent by dduchemin AT mednet.ucla DOT edu via Backup Central.
> |Forward SPAM to abuse AT backupcentral DOT com.
> +----------------------------------------------------------------------