Video: How to create command line scripts from tsql (4220794)

To easily create an accurate command line script for LiteSpeed processes, the feature "show_cmd" may be utilized.

If the default database for the SQL Server Service has the restore database as it's default database, then the restore cannot be called from the LiteSpeed GUI or from Query Analyzer, it can only be called via command line.

WORKAROUND:

Please see the video below:

From the SSMS Query Analyzer window, edit the tsql for the LiteSpeed process (xp_backup_database, xp_restore_database, etc.) with the parameter "show_cmd". The output is the correct command line syntax.

This:
execmaster.dbo.xp_backup_database show_cmd,@database =Northwind
,@filename = 'D:Backup\2005\Northwind.bak'
, @backupname = 'Master'
, @desc = 'Backup of Master'
, @logging = 0
, @init=1
 

Turns into this:
F:\LiteSpeed\6.5.0.1388\Engine\SQLLitespeedx32.exe -L 0 -B "Database" -D "Northwind" -F "D:Backup\2005\Northwind.bak" -n "Master" -d "Backup of Master" -I "1" -S "ALV203682\CYNTHIA"

Also see SOL72828