Inactivate positional parameters

Edit online

Positional parameters immediately follow the inactivate command and precede the optional parameters.

FIle=*|logicalfilename,...
This option deactivates only the active 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 deactivate.
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.
  • If logicalfilename includes spaces or special characters, enclose it in double quotes.
  • The logicalfilename variable is case-sensitive.
FULL
This option deactivates only the active full database backup objects for the SQL Server databases you specify. Each SQL Server database backed up creates a separate backup object on the IBM Storage® Protect server. A new full database backup object deactivates all prior active backup objects for the same SQL Server database. This inactivation includes any active full backup object as well as any active file, group, set, differential, and log backup objects.
DIFFerential
This option deactivates only the active differential database backup object. Because each SQL Server database backup creates a separate backup object on the IBM Storage Protect server, a new differential database backup object deactivates any active differential backup object for the same SQL Server database. Use this option so that all individual log backups since the last full database backup do not need to be applied.
Group=*|groupname,...
This option deactivates only the active group database backup object for the SQL Server database you specify. The groupname variable specifies the names of the SQL Server database filegroups you want to deactivate.
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.
Log or Log=*|logobjectname,...
This option deactivates only the active log database backup object for the SQL Server database you specify. This parameter takes the wildcard or logobjectname value. The logobjectname variable specifies the log backup objects to deactivate. 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 deactivates only the active set database backup object for the SQL Server database you specify. This parameter takes the wildcard or setobjectname value. The setobjectname variable specifies the set backup objects to deactivate. 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. You can specify this parameter more than once per command invocation.