IBM® IBM Storage Protect Snapshot commands for SQL Server

Edit online
The name of the IBM Storage Protect Snapshot for SQL Server command-line interface is tdpsqlc.exe. If you installed the TDPSQL package, or you configured the Microsoft SQL Server in Microsoft Management Console (MMC), the program is located (by default) in the IBM Storage Protect Snapshot installation directory (
C:\Program
               Files\Tivoli\tsm\TDPSQL
).
Command-line parameter characteristics
The command-line parameters have the following characteristics:
  • Positional parameters do not include a leading slash (/) or dash (-).
  • Optional parameters can display in any order after the required parameters.
  • Optional parameters begin with a forward slash (/) or a dash (-).
  • Minimum abbreviations for keywords are indicated in uppercase text.
  • Some keyword parameters require a value.
  • For those keyword parameters that require a value, the value is separated from the keyword with an equal sign (=).
  • If a parameter requires more than one value after the equal sign, the values are separated with commas.
  • Each parameter is separated from the others by using spaces.
  • If a parameter value includes spaces, the value must be enclosed in double quotation marks.
  • A positional parameter can display only once per command invocation.
Where repeatable syntax displays, separate multiple values with commas as indicated in the following example:
TDPSQLC command
Read syntax diagramSkip visual syntax diagramTDPSQLCBackup,dbname*
T o select all instances on the server of database names or file names, specify the asterisk (*) wildcard character following the command.
Command-line interface help

Issue the tdpsqlc ? or tdpsqlc help command to display help for the command-line interface. You can see more specific help for commands by entering a command like the following example: tdpsqlc help backup, where backup is an example of a command.

  • Backup command Use the backup command to back up all or part of one or more SQL databases from the SQL Server to IBM Storage Protect Snapshot.

  • Delete backup command

    Use the delete backup command to delete a VSS backup of a SQL Server database.

  • Help command

    Use the tdpsqlc help command to display help for IBM Storage Protect Snapshot for SQL Server commands.

  • Mount Backup command

    Use the mount backup command to mount backups that are managed by IBM Storage Protect Snapshot for SQL Server.

  • Policy commands for IBM Storage Protect Snapshot for SQL

  • Query FCM command

    Use the query fcm command to display IBM Storage Protect Snapshot information.

  • Query Managedcapacity command

    Use the Query Managedcapacity command to assist with storage planning by determining the amount of managed capacity in use.

  • Query SQL command

    The query sql command queries the local SQL Server to return general information and status about the SQL Server, databases, and VSS components.

  • Query TDP command

    Use the query tdp command to query a list of the current values set in the configuration file for IBM Storage Protect Snapshot for SQL Server.

  • Restore command

  • Restorefiles command

    Use the restorefiles command to restore VSS-based backups on theIBM Storage Protect (/BACKUPDESTINATION=TSM), or stored locally (/BACKUPDESTINATION=LOCAL).

  • Set command

    Use the set command to set the IBM Storage Protect Snapshot for SQL Server configuration parameters that are defined in the IBM Storage Protect Snapshot for SQL Server configuration file, tdpsql.cfg by default.

  • Unmount Backup command

    Use the unmount backup command to unmount backups that are previously mounted, and are managed by IBM Storage Protect Snapshot for SQL Server.

Related tasks