Page History
...
When you use the SQLsafeCmd command, the following actions can be performed:
Actions | Description | Example |
---|---|---|
Help | Display detailed descriptions and available options. | SQLsafeCmd help <action> |
Backup a database. | SQLsafeCmd help backup | |
Restore | Restore a database. | SQLsafeCmd help restore |
RestoreLast | Restore the most recent full backup of a database from the specified directory. | SQLsafeCmd help restorelast |
InstantRestore | Instant Restore a database. | SQLsafeCmd help instantrestore |
Verify | Verify a database backup. | SQLsafeCmd help verify |
RestoreFileListOnly | List files for database in backup set. | SQLsafeCmd help restorefilelistonly |
RestoreHeaderOnly | List backup sets in an archive. | SQLsafeCmd help restoreheaderonly |
Browse Tivoli Storage Management. | SQLsafeCmd help browse TSM | |
Expire TSM | Expire Tivoli Storage Management backup archives. | SQLsafeCmd help expire TSM |
Extract TSM | Extract a file from Tivoli Storage Management. | SQLsafeCmd help extract TSM |
License | Register a Backup Agent license. | SQLsafeCmd help license |
EncryptBackupPassword | Encrypt plain-text password for encrypted backups. | SQLsafeCmd help encryptbackuppassword |
EncryptRestorePassword | Encrypt plain-text password for encrypted restores. | SQLsafeCmd help encryptrestorepassword |
EncryptSqlPassword | Encrypt plain-text password for SQL Server logins. | SQLsafeCmd help encryptsqlpassword |
EncryptWindowsPassword | Encrypt plain-text password for Windows logins. | SQLsafeCmd help encryptwindowspassword |
InstallXsp | Install SQL Server extended stored procedures for SQLsafe. | SQLsafeCmd help installxsp |
Delete | Delete backup archives older than the specified date. | SQLsafeCmd help delete |
LogShipBackup | Log Shipping primary backup. | SQLsafeCmd help logshipbackup |
LogShipRestore | Log Shipping secondary restore. | SQLsafeCmd help logshiprestore |
ObjectLevelRecovery | Restore database objects. | SQLsafeCmd help objectlevelrecovery |
Create-Policy | Create a new policy. | SQLsafeCmd help create-policy |
Edit-Policy | Edit existing policy. | SQLsafeCmd help edit-policy |
AddDatabase | Deploy new database for existing policy (LogShipping or Backup policy). | SQLsafeCmd help adddatabase |
Virtual Database | Display detailed descriptions and available options. | SQLvdbCmd help |
Info |
---|
The examples in the above table provides you with commands to use in Command Prompt. Those commands will display detailed descriptions and available options for each action. |
...