A directorycannot be chosen to backup as an attachment for maintenance plans (single files may be selected).
N/A
WORKAROUND:
Add the tsql for the LiteSpeed backup into a SSMS job and schedule it. You’ll get the LiteSpeed function on the backup, with the directory attached to the backup file.
EXAMPLE:
exec master.dbo.xp_backup_database
@database = N'model',
@backupname = N'model - Full Database Backup',
@desc = N'Full Backup of model',
@compressionlevel = 2,
@filename = N'C:\Backup\2005\%D_%T_%Y-%m-%d-%H%M%S.bak',
@init = 1,
@with = N'STATS = 10',
@attachedfile = N'D\Backup\2005\Error Logs'
GO
STATUS: Fixed in a future version of LiteSpeed for SQL Server.
