Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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).



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 |
 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse