SQL Safe provides you with CLI commands to help you manually add databases.


To add databases use the following commands:
  • SQLsafeCmd AddDatabase <policy_name> <db_name>
  • SQLsafeCmd AddDatabase <policy_guid> <db_name>
  • SQLsafeCmd AddDatabase <policy_name> <instance_name> <db_name> [primary|secondary]
  • SQLsafeCmd AddDatabase <policy_guid> <instance_name> <db_name> [primary|secondary]


Where: 
ActionDescription

<policy_name>

Name of the policy.

<policy_guid>

GUID of the policy.

<db_name>

Name of the database.

<instance_name>

Specifies the instance name.

 {server, instance}.

Note: this parameter is optional for Backup policy and required for LogShipping policy.

[primary|secondary]

Specifies the location.

Note: the default value is "secondary" database.

this parameter is optional for LogShipping policy.

For detailed descriptions and available options, see the CLI Help (SQLsafeCmd help AddDatabase).



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels