Query Restore
The query restore command displays a list of your restartable restore sessions in the server database. The list contains these fields: owner, replace, subdir, preservepath, source, and destination.
A restartable restore session is created when a wildcard restore command fails because of network outage, client failure, server outage, or a similar problem. When such a failure occurs, the file space is locked on the server and its files cannot be moved off the sequential volumes of the server. To unlock the file space, either restart the restore and allow it to complete (query restore command), or cancel the restore (cancel restore command). Use query restore to determine if you have any restartable restore sessions and which file spaces are affected.
![Mac OS X operating systems](ngmacosx.gif)
![Windows operating systems](ngwin.gif)
![Oracle Solaris operating systems](ngsolaris.gif)
![Linux operating systems](nglinux.gif)
![AIX operating systems](ngaix.gif)
Supported Clients
This command is valid for all clients.
Syntax
Parameters
There are no parameters for this command.
Examples
Task
The following example displays the output when you use query restore:
--- Restartable Restore Information --- Restartable Session: 1 Start date/time: 10/17/2001 15:18:22 Source: {"\\ers\c$"}\data\proposals\* Destination: - not specified by user - Restartable Session: 2 Start date/time: 10/17/2001 15:20:01 Source: {"\\ers\c$"}\data\spreadsheets\* Destination: - not specified by user -
Task
Display your restartable restore session in the server database.
Command:
query restore