Does LiteSpeed support SQL Server Copy only backups? (4220692)

Native SQL Server 2005 supports full and log backups that are a copy-only backup, which does not affect the normal sequence of backups (LSN numbers). A copy-only backup is created independently of the regularly scheduled, conventional backups.

Copy-only backups were introduced in SQL Server 2005 for use when the backup's sequence is not the priority, such as backing up the log before an online file restore.

Example: BACKUP DATABASE database_name TO <backup_device>, WITH COPY_ONLY

LiteSpeed extended stored procedures support the 'COPY_ONLY' feature in SQL Server 2005 (this feature is not available in SQL Server 2000 or SQL Server 6.5 or 7.0).
Example:
exec master.dbo.xp_backup_database
@database = N'Northwind',
@backupname = N'Northwind - Full Database Backup',
@desc = N'Full Backup of Northwind on 6/12/2009 1:16:35 PM',
@compressionlevel = 1,
@filename = N'd:\backup\northwind_full_copy.bak',
@init = 1,
@with = N'SKIP',
@with = N'STATS = 10',
@with = COPY_ONLY
GO

For additional information, see:
http://technet.microsoft.com/en-us/library/ms186865.aspx and http://technet.microsoft.com/en-us/library/ms191495.aspx

Running a full backup between the regularly scheduled full backups, does not cause sequence problems with the transaction log backup LSN sequence numbers. However, it can affect the differential backups LSN numbers. The same is true for an additional transaction log backups during regularly scheduled tlog backup jobs, it could cause difficulty when restoring.

Copy-only function allows a non-regular scheduled backup, at any time, without changing the log sequence numbers stored in the backup files. So a restore of a series of backups could exclude the copy_only backup file and still be successful.

BACKUP LOG, the COPY_ONLY option creates acopy-only log backup, which does not truncate the transaction log. The copy-only log backup has no effect on the log chain, and other log backups behave as if the copy-only backup does not exist.

Generally speaking, COPY_ONLY is used to refresh a development or test environment and then discarded.