Reference
Reference topics provide information related to Data Protection for Microsoft SQL Server . Topics include information about the
commands that you can issue at the command-line interface as an alternative to using Microsoft Management Console (MMC) and frequently asked questions about
Data Protection for Microsoft SQL Server .
Command-line overview Data Protection for SQL Server command-line interface is tdpsqlc.exe . This program is in the directory where Data Protection for SQL Server is installed.Data Protection for SQL Server parameters by backup method Backup command backup command to back up all or part of one or more SQL Server databases from the SQL Server to IBM Spectrum Protect storage on the IBM Spectrum Protect server .Changetsmpassword command IBM Spectrum Protect password that is used by Data Protection for SQL Server , use the changetsmpassword command. The password is used to log on to the IBM Spectrum Protect server .Delete Backup command delete backup command to delete a VSS backup of an SQL Server database.Help command tdpsqlc help command to display the syntax of all or selected Data Protection for SQL Server commands using a textual notation.Inactivate command (Legacy only) inactivate command to deactivate one or more active legacy backup objects on the IBM Spectrum Protect server .Mount Backup command mount backup command.Query command query command to display information about the SQL Server and its databases, about the IBM Spectrum Protect server and its backup objects, and about Data Protection for SQL Server .Query Managedcapacity command Query Managedcapacity command to assist with storage planning by determining the amount of managed capacity in use.Query Policy command query policy command to query local policy information.Restore command restore command to restore all or part of one or more SQL Server databases.Restorefiles command restorefiles command to restore VSS-based backups on the IBM Spectrum Protect server (/BACKUPDESTINATION=TSM), or stored locally (/BACKUPDESTINATION=LOCAL).Set command set command to change the values for the Data Protection for SQL Server configurable parameters and options.Unmount Backup command unmount backup command to unmount backups that have been previously mounted, and are managed by IBM Spectrum Protect Snapshot for SQL Server .Frequently asked questions Data Protection for SQL Server .