new, setup  

Owned by Vijayganesh Sivaprakasam
Nov 20, 2024
2 min read
dbvcli new {-t|--type} mssql [--OPTIONS] dbvcli setup {-t|--type} mssql [--OPTIONS]

Create a new SQL Server Configuration

Option

Type

Description

Option

Type

Description

--license

string

license key

--source-db

string

name of source database

--source-host

string

host name of instance containing source database

--source-instance

string

name of instance containing source database

--add-source-instance

 

add new source instance

--source-port

string

port number of instance to add (used when adding source instance)

--source-auth-type

auth

authentication type, value should be either 'SQL' or 'WIN' (used when adding source instance)

--source-password

string

password for authentication to instance (used when adding source instance)

--source-username

string

user name for authentication to instance (used when adding source instance)

--source-log-dir

string

log backup location on source host

--standby-host

string

host name of instance for standby database

--standby-instance

string

name of instance for standby database

--add-standby-instance

 

add new standby instance

--standby-port

string

port number of instance to add (used when adding standby instance)

--standby-auth-type

auth

authentication type, value should be either 'SQL' or 'WIN' (used when adding standby instance)

--standby-password

string

password for authentication to instance (used when adding standby instance)

--standby-username

string

user name for authentication to instance (used when adding standby instance)

--standby-log-dir

string

log backup location on standby host

C:\Program Files\Dbvisit\standbymp\bin>dbvcli.exe -t mssql setup Connecting to the Control Center at SQLDR1:4433 ✓ Source Database 1/3 Select the host of the instance containing the source database. Source Host: ( ) SQLDR1 (•) SQLPROD1 Source Database 2/3 Select the instance containing the source database. Source Instance: (•) SQLEXPRESS ( ) Add new instance Source Database 3/3 Select the source database. Source Database: (•) link ( ) mine ( ) new Standby Database 1/2 Select the host for the standby database. Standby Host: (•) SQLDR1 ( ) SQLPROD1 Standby Database 2/2 Select the instance for the standby database. Standby Instance: (•) SQLEXPRESS ( ) Add new instance Custom Log Backup Locations 1/2 Enter the directory for log backups on the source host. Leave blank to use the default backup directory that was chosen during installation of the agent on the source host. Source Log Backup Directory: > c:\backup Custom Log Backup Locations 2/2 Enter the directory for log backups on the standby host. Leave blank to use the default backup directory that was chosen during installation of the agent on the standby host. Standby Log Backup Directory: > c:\backup License Key Enter a license key for this instance pair. License Key: > 4jo70-qwp4l-7gplh-g1erb-pjpnk-2o1za-eviga New configuration link was created successfully. Configuration link (SQLPROD1 -> SQLDR1) ┌───────────────┐┌───────────────┐ │ ││ │ │ Primary ││ Standby │ │ ││ │ │ ONLINE ││ No standby │ │ ││ database │ │ ││ │ └───────────────┘└───────────────┘