LiteSpeed for SQL Server 8.9.8 - Security and Compliance Guide

Introduction LiteSpeed Security Features LiteSpeed for SQL Server and FISMA Compliance Customer Measures

Backup examples - extended stored procedures

Backup examples are included for often used extended stored procedures. All backup type examples, disk backup examples, cloud backup examples, TSM backup examples, and tape examples are categorized. In each category locate the extended stored procedure in the Use this procedure.. column and then select the example link in the To run these backups... column.

All backup type examples

Use this procedure...	To run these backups...
xp_backup_database	Back Up Database with Init
''	Create Differential Backup
''	Back Up Database with Encryption
''	Back Up Database with Multiple Threads
''	Multiple Backup Devices (Striped Backup)
''	Create Filegroup Backup
''	Create Differential Filegroup Backup
''	Create Partial Backup (includes the primary filegroup, all read/write secondary filegroups, and a specified read-only file)
''	Backup all databases
''	Backup user databases
''	Backup selected databases
xp_slsFastCompression	Full backup change of 40%
''	Full backup to multiple locations
''	Force full backup
''	Backup showing FastCompressionExtension argument

Disk backup examples

Use this procedure...	To run these backups...
xp_backup_database	xp_backup_database (Disk)
xp_backup_log	Back Up Log (Disk)

Cloud backup examples

Use this procedure...	To run these backups...
xp_backup_database	Backup database to Amazon S3
"	Backup database to Amazon S3 using @CloudStorageClass
"	xp_backup_database (Amazon S3 using temporary security credentials)
"	Backup database to Microsoft Azure
"	Backup database to Google Cloud Storage
"	Backup database to S3 Compatible storage
xp_backup_log	Back Up Log (Microsoft Azure)
"	Back Up Log (Microsoft Azure)
"	Back Up Log (Google Storage)
"	Back Up Log (S3 Compatible Storage)
xp_slsFastCompression	sls_FastCompression (Microsoft Azure)

TSM backup examples

Use this procedure...	To run TSM backups...
xp_backup_database	xp_backup_database (TSM)
''	Create TSM Archive
xp_backup_log	Back Up Log (TSM)
xp_slsFastCompression	Backup to TSM change of 40%

Tape backup examples

Use this procedure...	To run these backups...
xp_backup_database	Back Up Database to Tape
''	xp_backup_database (Tape)
xp_backup_log	Back Up Log (Tape)