Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

SQL Safe Backup provides you with a Command Line Interface (CLI) to automate its functions. The CLI commands allow you to make changes to your SQL Safe Backup configurations across multiple SQL Server instances in a few lines of text, saving you time.

About Command Line Interface (CLI)

A Command Line Interface (CLI) is a user interface that allows you to interact with the operating system. The interaction is performed through commands where you type an type a specific command and the operating system performs an action.

Tip

Make sure you are aware of the proper command format for each action you want to perform.

SQL Safe Backup CLI Usage

The following commands help you automate your SQL Safe Backup functions:

...

When you use the SQLsafeCmd command, the following actions can be performed:

ActionsDescriptionExample
HelpDisplay detailed descriptions and available options.SQLsafeCmd help <action>

Backup

Backup a database.SQLsafeCmd help backup
RestoreRestore a database.SQLsafeCmd help restore
RestoreLastRestore the most recent full backup of a database from the specified directory.SQLsafeCmd help restorelast
InstantRestoreInstant Restore a database.SQLsafeCmd help instantrestore
VerifyVerify a database backup.SQLsafeCmd help verify
RestoreFileListOnlyList files for the database in the backup set.SQLsafeCmd help restorefilelistonly
RestoreHeaderOnlyList backup sets in an archive.SQLsafeCmd help restoreheaderonly

Browse TSM

Browse Tivoli Storage Management.SQLsafeCmd help browse TSM
Expire TSMExpire Tivoli Storage Management backup archives.SQLsafeCmd help expire TSM
Extract TSMExtract a file from Tivoli Storage Management.SQLsafeCmd help extract TSM
LicenseRegister a Backup Agent license.SQLsafeCmd help license
EncryptBackupPasswordEncrypt plain-text password for encrypted backups.SQLsafeCmd help encryptbackuppassword
EncryptRestorePasswordEncrypt plain-text password for encrypted restores.SQLsafeCmd help encryptrestorepassword
EncryptSqlPasswordEncrypt plain-text password for SQL Server logins.SQLsafeCmd help encryptsqlpassword
EncryptWindowsPasswordEncrypt plain-text password for Windows logins.SQLsafeCmd help encryptwindowspassword
InstallXsp
InstallXSPInstall SQL Server extended stored procedures for SQLsafe.SQLsafeCmd help installxsp
DeleteDelete backup archives older than the specified date.SQLsafeCmd help delete
LogShipBackupLog Shipping primary backup.SQLsafeCmd help logshipbackup
LogShipRestore         Log Shipping secondary restore.SQLsafeCmd help logshiprestore
ObjectLevelRecoveryRestore database objects.SQLsafeCmd help objectlevelrecovery
Create-PolicyCreate a new policy.SQLsafeCmd help create-policy
Edit-PolicyEdit existing policy.SQLsafeCmd help edit-policy
Copy-PolicyCopy existing policy.SQLsafeCmd help copy-policy
AddDatabaseDeploy a new database for the existing policy (LogShipping or Backup policy).SQLsafeCmd help adddatabase
Virtual DatabaseDisplay detailed descriptions and available options.SQLvdbCmd help
MountVDBCreate a new virtual database.SQLsafeCmd help MountVDB
UnmountVDBDelete a virtual database.SQLsafeCmd help UnmountVDB
CleanupVDBCleanup unused virtual database temporary files.SQLsafeCmd help CleanupVDB
Info

The examples in the above table provides table provide you with commands to use in Command Prompt. Those commands will display detailed descriptions and available options for each action.

...