Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.9.5 - Security and Compliance Guide

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)

 

 

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating