Page History
...
- SQLsafeCmdBackup <db_name> [<db_name>] TRUNCATEONLY [options]
| Action | Description |
|---|---|
| <db_name> | One or more names of database(s) to backup. If a database name contains a space, the database name should be surrounded with "double quotes". Special keywords may be used to backup multiple databases. These keywords are: {all}, {allsystem}, {alluser}. |
<backup_archive> | Path to the backup archive. |
| Tsm | Use Tivoli Storage Manager (see below for special options). |
| TruncateOnly | Use this keyword to truncate the transaction log of the SQL Server database only. |
Common Options
The following options help you perform backup operations:
...
Secure your backups with the following options:
| Options | Description |
|---|---|
| -NoPrompt | Never prompt for credentials even if necessary. |
| -SecurityModel <model> | The security model used to log into SQL Server. <model> - {Integrated, SQL}. Note: Integrated (Windows authentication) is the default. |
| -SqlUsername <username> | <username> - the SQL Server username. (SQL SecurityModel). |
| -SqlPassword <pwd> | <pwd> - the SQL Server password. (SQL SecurityModel). |
| -EncryptedSqlPassword <pwd> | <pwd> - the encrypted SQL Server password generated by EncryptSqlPassword action. (SQLSecurityModel). |
| -WindowsUsername <domain\user> | <domain\user> - the Windows user that will be used to read/write the backup archive. |
| -WindowsPassword <pwd> | <pwd> - the password for the Windows user. |
| -EncryptedWindowsPassword <pwd> | <pwd> - the encrypted password for the Windows user generated by EncryptWindowsPassword action. |
Advanced Options
The following advanced options help you perform backup operations:
...
There are TSM options for your backup operations:
| Options | Description |
|---|---|
| -TsmClientOwnerName <name> | <name> - the client owner name. |
| -TsmClientOwnerPassword <pwd> | <pwd> - the client owner password. |
| -EncryptedTsmClientOwnerPassword <pwd> | <pwd> - the encrypted TSM client owner password. |
| -TsmConfigFile <filename> | <filename> - the configuration file location. |
| -TsmHighLevel <name> | <name> - the high level file specification (path). |
| -TsmLowLevel <name> | <name> - the low level file specification (file name). |
| -TsmTcpServerAddress <address> | <address> - the TCP/IP address for the TSM server. |
| -TsmTcpPort <port> | <port> - the TCP/IP port address for the TSM server. |
| -TsmManagementClass <name> | <name> - the management class to which the backup file will be bound. |
For detailed descriptions and available options, see the CLI Help (SQLsafeCmd help Backup).
...