Mirror option for the Lite Speed Maintenance Plans to allow two backup files to be written simutaneously to two locations, is not available for the Full Backup when creating a maintenance plan within the LiteSpeed maintenance plan GUI setup.
The mirror option is not available for the Full Backup when creating a maintenance plan.
Create a LiteSpeed maintenanance plan using SQL and the parameters in the example below. The script may be generated using the Backup Database Wizard in LiteSpeed and copying the script in the 'View Script' window.
@database = N'Northwind'
, @filename = N'D:\Backup\2005\Northwind200704121401LiteSpeed_Full.BKP'
, @mirror = N'E:\Archives\Northwind200704121401LiteSpeed_Full.BKP'
, @backupname = N'Northwind backup'
, @desc = N'Backup of Northwind on 2007-04-12 14:01:22'
, @logging = 0
, @with = N'SKIP'
, @with = N'STATS = 10'
Enhancement request has been submitted to Development for consideration in a future release of LiteSpeed for SQL Server.