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:
| Action | Description |
|---|---|
<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).