Restore positional parameters
Positional parameters immediately follow the restore command and precede the optional parameters.
- FIle=*|logicalfilename,...
- A file backup contains only the contents
of the SQL Server logical file you specify. You can use this option
when it is not practical to back up an entire SQL Server database
due to available backup time and space or due to performance requirements.
This option restores file backup objects for the SQL Server databases
you specify. The logicalfilename variable specifies the names
of the SQL Server database logical files you want to restore to. Considerations:
- You can specify this parameter more than once per command invocation.
- Use * as a wildcard character in logicalfilename to replace zero or more characters for each occurrence. Specifying only the wildcard character indicates all logical files in the SQL Server database. Since each logical file backed up creates a separate backup object on the IBM Storage® Protect server, specifying only the wildcard character results in a separate backup object for each logical file in the SQL Server database.
- If logicalfilename includes spaces or special characters, enclose it in double quotes.
- The logicalfilename variable is case-sensitive.
- You cannot specify the /recovery parameter with restore file operations.
- FULL
- This option restores all full database backup objects for the SQL Server databases you specify.
- COPYFull
- This option restores a copy-only full backup, which contains a copy-only version of a full backup. These backups are considered out of the regular sequence of backups, and do not affect the transaction logs or any sequence of backups like differential backups or full backups.
- DIFFerential
- A differential database backup contains only the parts of a SQL Server database changed since the latest full backup plus enough of the SQL Server database's transaction log to make a restore consistent. As such, a differential backup usually takes up less space than a full backup. Use this option so that all individual log backups since the last full database backup do not need to be applied. This option saves time during a restore by replacing the restore of a number of transaction log backups.
- Group=*|groupname,...
- This option restores
all group database backup objects for the SQL Server databases you
specify. The groupname variable specifies the names of the
SQL Server database filegroups you want to restore. Considerations:
- You can specify this parameter more than once per command invocation.
- Use * as a wildcard character in the groupname variable to replace zero or more characters for each occurrence.
- Specifying only the wildcard character indicates all filegroups in the SQL Server database.
- If the groupname variable includes spaces or special characters, enclose it in double quotes.
- The groupname variable is case-sensitive.
- You cannot specify the /recovery parameter with restore group operations.
- Log or Log=*|logobjectname,...
- This option restores all log database backup objects for the SQL Server databases you specify. The log parameter takes the wildcard or logobjectname value. The logobjectname variable specifies the log backup objects to restore. Use * as a wildcard character in logobjectname to replace zero or more characters for each occurrence. Specifying only the wildcard character indicates all log backup objects for the SQL Server databases. You can specify this parameter more than once per command invocation.
- Set or Set=*|setobjectname,...
- This option restores
all set database backup objects for the SQL Server databases you specify.
The set parameter takes the wildcard or setobjectname value.
The setobjectname variable specifies the set backup objects
to restore. Use * as a wildcard character in setobjectname to
replace zero or more characters for each occurrence. Specifying only
the wildcard character indicates all set backup objects for the SQL
Server databases. Considerations:
- You can specify this parameter more than once per command invocation.
- You cannot specify the /recovery parameter with restore set operations.