Query command
Use the query command to display information about the SQL Server and its databases, about the IBM Storage® 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