Can LiteSpeed's Create Unique Media be used when a backup is striped across multiple files?
Can this functionality be called via the LiteSpeed Console GUI or t-sql script?
WORKAROUND:
Via the LiteSpeed Console GUI, on the Backup Destination screen, select "Create unique media"
-OR-
via t-sql script
declare @rawScript nvarchar(4000)
set @rawScript = N'
exec master.dbo.xp_backup_database
@database = N''Pubs'',
@backupname = N''Pubs - Full Database Backup'',
@desc = N''Full Backup of Pubs on %Y-%m-%d %I:%M:%S %p'',@compressionlevel = 2,
@filename = N''C:\Backup\2005\Pubs_one{0}.bak'',
@filename = N''C:\Backup\2005\Pubs_two{0}.bak'',
@init = 0,
@with = N''STATS = 10'''
declare @appendDate nvarchar(1024)
set @appendDate = '_' + left(replace(replace(replace(convert(nvarchar, getdate(), 120), '-', ''), ':', ''), ' ', ''), 14)
declare @script nvarchar(4000)
set @script = replace(@rawScript, '{0}', @appendDate)
exec (@script)
GO
Results of both methods:
C:\Backup\Pubs_one_20140401152524.bak
C:\Backup\Pubs_two_20140401152524.bak
