Return
-
Title
How to mirror transaction log backups -
Description
How to mirror transaction log backups; this feature is not available via the LiteSpeed GUI
Note: Mirroring of transaction log backups is not available for Log Shipping -
Resolution
The following script may be dropped into a maintenance plan or as a scheduled job:
exec master.dbo.xp_backup_log
@database = 'Northwind',
@filename = 'C:\Program Files\Microsoft SQL Server\MSSQL$CYNTHIAS\BACKUP\Northwind_LiteSpeed_tlog.BKP',
@mirror = 'C:\Program Files\Microsoft SQL Server\MSSQL$CYNTHIAS\BACKUP\Northwind_tlog_mirror1',
@mirror = 'C:\Program Files\Microsoft SQL Server\MSSQL$CYNTHIAS\BACKUP\Northwind_tlog_mirror2',
@backupname = 'Northwind backup',
@desc = 'Backup of Northwind on 2008-02-19 11:46:23',
@init = 1,
@logging = 0,
@with = 'SKIP',
@with = 'STATS = 10'