Can NCS run the backup command in a script where the T-SQL commands are built dynamically.
Example :
declare @sql_cmd varchar(250)
select @sql_cmd = 'BACKUP DATABASE pubs2 TO DISK='+char(39)+'C:backups\pubs.bak'+char(39)+' WITH STATS=10,init'+char(13)
exec (@sql_cmd)
Only explicit backup commands are regonised by NCS to perform a LiteSpeed backup. Backup commands constructed in scripts as in the example above, will be ignored by NCS and a native backup will be executed.
