- Create Policy
- This command is used to create a policy.
TDPSQLC command: CREATE POLicy
>>-TDPSQLC--CREATE POLicy--policy_name-------------------------->
>--+----------------------------------+------------------------->
| .-=dsm.opt--------. |
'-/FCMOPTFile--+-----------------+-'
'-=dsmoptfilename-'
>--+---------------------------+-------------------------------->
| .-2-------. |
'-/VERSretain=--+-number--+-'
'-NOLimit-'
>--+---------------------------+-------------------------------><
| .-30------. |
'-/DAYSretain=--+-number--+-'
'-NOLimit-'
Parameters:- policy_name (required): Specifies the name of the policy that is being created. To create a policy, the policy name must be unique.
- VERSretain: Specifies the number of snapshot versions to retain (1 - 9999). You can also specify NOLimit to represent an unlimited number of snapshot versions to retain.
- DAYSretain: Specifies the number of days to retain a snapshot (0 - 9999). You can also specify NOLimit to represent an unlimited number of days to retain snapshot versions.
- Update Policy
- This command is used to update or modify the retention parameters
of an existing policy.
TDPSQLC command: UPDATE POLicy
>>-TDPSQLC--UPDATE POLicy--policy_name--+-------------------+--->
'-/NEWname=--string-'
>--+----------------------------------+------------------------->
| .-=dsm.opt--------. |
'-/FCMOPTFile--+-----------------+-'
'-=dsmoptfilename-'
>--+---------------------------+-------------------------------->
'-/VERSretain=--+-number--+-'
'-NOLimit-'
>--+---------------------------+-------------------------------><
'-/DAYSretain=--+-number--+-'
'-NOLimit-'
Parameters:
- NEWname: Specifies the new name of the policy, if the name is being updated. The policy name must be unique.
- policy_name (required): Specifies the name of the policy that is being updated.
- VERSretain: Specifies the number of snapshot versions to retain (1 - 9999). You can also specify NOLimit to represent an unlimited number of snapshot versions to retain.
- DAYSretain: Specifies the number of days to retain a snapshot (0 - 9999). You can also specify NOLimit to represent an unlimited number of days to retain snapshot versions.
- Copy Policy
- This command is used to copy an existing policy to a new policy.
TDPSQLC command: COPY POLicy
>>-TDPSQLC------------------------------------------------------>
>--COPY POLicy--existing_policy_name--new_policy_name----------->
>--+----------------------------------+------------------------><
| .-=dsm.opt--------. |
'-/FCMOPTFile--+-----------------+-'
'-=dsmoptfilename-'
Parameters:
- existing_policy_name (required): Specifies the name of the policy that is being copied.
- new_policy_name (required): Specifies the name of the new policy. The policy name must be unique.
- Query Policy
- This command is used to list the attributes of a policy.
TDPSQLC command: Query POLicy
>>-TDPSQLC--Query POLicy--*------------------------------------><
Parameters: * (required) Specifies all policies are to be queried. The results of the query are displayed as follows:
Connecting to SQL Server, please wait... Policy Number of snapshots to keep Days to keep a snapshot -------- -------------------------- ---------- FCMPOL 3 60 STANDARD 2 30 - Delete Policy
- This command is used to delete a policy.
TDPSQLC command: DELete POLicy
>>-TDPSQLC--DELete POLicy--policy_name-------------------------->
>--+----------------------------------+------------------------><
| .-=dsm.opt--------. |
'-/FCMOPTFile--+-----------------+-'
'-=dsmoptfilename-'
Parameter:
- policy_name (required): Specifies the name of the policy that is being deleted.