Using the Command Line Interface › ca_backup - Backup Manager Command › ca_backup - Database Options › ca_backup - SQL Server Database Options › ca_backup - SQLServer Agent Options

ca_backup - SQLServer Agent Options

The ca_backup command includes the following SQLServer Agent options:

ca_backup 

[-sql_full | -sql_diff | -sql_log <trunc|no_trunc|no_recovery>]
[-sql_log_afterdata <trunc|no_trunc|no_recovery>][-sql_partial]
[-sql_filegroup <filegroupname> [-sql_file <filename1>]...[-sql_file<filenamen>]]...
[-sql_dbcc [sql_before [continue]] [sql_after] [physical_only] [no_indexes]]
[-sql_checksum]

Note: The ca_backup database options are described in a separate topic titled "Database Options" and can be viewed from the actual CLI by entering the following command: ca_backup allusage.

-sql_full

Specifies to perform a Full SQLServer backup.

-sql_diff

Specifies to perform a Differential SQLServer backup.

-sql_log

Specifies to perform a Transaction Log backup.

trunc

Specifies to truncate the Transaction Logs when you back them up. This option removes all inactive entries from the Transaction Log. If the Transaction Log is not truncated, it may eventually grow very large.

no_trunc

Specifies not to truncate the Transaction Logs when you back them up. This option does not remove the inactive entries from the Transaction Log.

no_recovery

Specifies to back up log tail and leave the database in a loading state.

The log tail is the oldest end of the log.

-sql_log_afterdata

Specifies to back up the transaction log after the database.

-sql_partial

Specifies to perform a partial backup.

-sql_filegroup <filegroupname>

Specifies the filegroups in the session to be backed up.

-sql_file <filename>

Specifies the files in the session to be backed up.

-sql_dbcc

Specifies to perform a database consistency check (DBCC).

sql_before [continue]

Specifies to perform a DBCC before the backup of the database.

You can also specify to continue with the backup even if the DBCC fails.

sql_after

Specifies to perform a DBCC after the backup of the database.

physical_only

Specifies to check only the physical consistency of the database to verify the structural integrity of all the objects in the database.

no_indexes

Specifies to check the database for consistency without checking indexes for user-defined tables.

-sql_checksum

Specifies to include checksums generated by SQL Server in the backup.

Examples:

The following are examples of syntax for the ca_backup SQL Server database command:

• Use the following command to perform a full database backup:

  -database SQL <instance name> <dbase name> -sql_full
  

• Use the following command to perform a differential database backup:

  -database SQL <instance name> <dbase name> -sql_diff
  

• Use the following command to perform a file or file group database backup:

  -database SQL <instance name> <dbase name> -sql_filegroup [-sql_file <filename>...]
  

• Use the following command to perform a database log backup:

  -database SQL <instance name> <dbase name> -sql_log[trunc|no_trunc|no_recovery]
  

More information:

ca_backup - Database Options

ca_backup - Examples