Query command
Use the 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.
Considerations:
- Some of the information displays may have long text lines. You can redirect the informational
output of the Data Protection for SQL Server query command to a text
file using the Windows command output redirection syntax
(command prompt):
- TDPcommandstatement > [[drive:]path\]filename.ext
- This creates or replaces the file.
- TDPcommandstatement >> [[drive:]path\]filename.ext
- This appends to the file.
You can then browse or edit the file.
- You can use the Windows more filter
command (command prompt) to display the informational output one screen
at a time, in conjunction with the Windows command
pipe character:
TDPcommandstatement | more