IBM Tivoli Storage Manager, Version 7.1

Cmdlets for protecting Microsoft SQL Server data

The following table identifies the cmdlets that are available for use to protect Microsoft SQL Server data.

Table 1. Cmdlets to protect Microsoft SQL Server data. The following table identifies the cmdlets that you can use to protect Microsoft SQL Server data.
Cmdlet name	Related command-line interface command	Short description
Add-DpSqlPolicy	tdpsqlc create policy	Create a new policy for Microsoft SQL Server data.
Backup-DpSqlComponent	tdpsqlc backup	Backup SQL components.
Copy-DpSqlPolicy	tdpsqlc copy policy	Copy an existing policy to a new policy.
Dismount-DpSqlBackup	tdpsqlc unmount backup	Dismount a backup.
Get-DpSqlBackup	tdpsqlc query tsm *	Query the backups that are stored on the server.
Get-DpSqlComponent	tdpsqlc query sql *	Query the databases that are available on the SQL server.
Get-DpSqlConfig	tdpsqlc query tdp	Display configuration information.
Get-DpSqlConnection	tdpsqlc query tsm	Displays the Tivoli Storage Manager API and server information.
Get-DpSqlFileGroups	not applicable	Displays all file and group information about specified SQL Server databases.
Get-DpSqlInformation	tdpsqlc query sql	Display specified SQL Server information.
Get-DpSqlManagedCapacity	tdpsqlc query managedcapacity	Assist with storage planning by determining the amount of managed capacity that is in use.
Get-DpSqlPolicy	tdpsqlc query policy	Query policy.
Mount-DpSqlBackup	tdpsqlc mount backup	Mounts a backup that provides access to the files that are contained by the backup.
Remove-DpSqlBackup	tdpsqlc delete backup and tdpsqlc inactivate	Use to delete a VSS backup of a SQL Server database, or inactivate one or more active legacy backup objects on the Tivoli Storage Manager server.
Remove-DpSqlPolicy	tdpsqlc delete policy	Deletes a local policy.
Reset-DpSqlTsmPassword	tdpsqlc changetsmpassword	Changes the Tivoli Storage Manager password used by Data Protection for SQL Server.
Restore-DpSqlBackup	tdpsqlc restore	Restore backups of Microsoft SQL Server data.
Set-DpSqlConfig	tdpsqlc set paramname	Set the Tivoli Storage FlashCopy Manager for SQL configuration parameters in the configuration file.
Set-DpSqlPolicy	tdpsqlc update policy	Changes an existing policy.

To view the details about a specific cmdlet, run the Get-Help cmdlet with the cmdlet name. For example:

Get-Help Get-DpSqlBackup

To continue the example, to see examples for the cmdlet, enter:

get-help Get-DpSqlBackup -examples

For more information, enter:

get-help Get-DpSqlBackup -detailed

For technical information, enter:

get-help Get-DpSqlBackup -full

To go to the information center, enter:

get-help Get-DpSqlBackup -online

For information about a specific parameter, enter:

help Get-DpSqlBackup -Parameter backupdestination

To display the help in a separate window, include the -showwindow parameter with the help command.

Feedback