How to create two backup files of the same database on different locations.
Earlier versions of LiteSpeed did not offer a mirroring function.
To obtain multiple copies of the backup file, a custom script must be created or multiple maintenance plans with differing destinations may be created.
To copy the backup file to one more location during the backup process, implement the a parameter in the t-sql script or create separate maintenance plans. To do the backup each maintenance plan would save the backup file on different destinations.
Also an external bat file to copy the backup file to the other destination would be possible; however, we do not provide the .BAT file.
Version 4.6x includes backup mirroring, creating an exact duplicate of the backup to a user specified location.
The latest version of LiteSpeed for SQL Server may be downloaded: http://support.quest.com/support_download/Downloads.asp
Tsql script would be similar to:
@database = 'Northwind',
@filename = 'D:BACKUPNorthwiond200806211146LiteSpeed_Full.BKP',
@mirror = 'D:BACKUPmirror1.bkp',
@mirror = 'D:BACKUPmirror2.bkp',
@backupname = 'Northwind backup',
@desc = 'Backup of Northwind on 2008-06-21 11:46:23',
@init = 1,
@logging = 0,
@with = 'STATS = 10'