create-standby, csd

dbvcli create-standby {-d|--name} CONFIGURATION_NAME [--OPTIONS]
dbvcli csd {-d|--name} CONFIGURATION_NAME [--OPTIONS]

Set up disaster recovery

Option	Type	Description
`--auto-update`	Y or N	enable automated standby update
`--auto-update-interval`	string	interval for automated standby update in seconds
`--db-file-loc`	key=val	location for database files on standby host; FILE_NAME=LOC; can be specified multiple times
`--observer`	Y or N	enable observer
`--source-backup-dir`	string	directory for full database backup on source host
`--standby-backup-dir`	string	directory for full database backup on standby host
`--compress-backup`	string	added in 12.3 compress the initial backup sent to the standby (on, off) the instance's default will be used otherwise
`--compress-logs`	string	added in 12.3 compress log backups for this configuration (on, off, auto) defaults to 'auto', which uses the instance's default setting

Example

C:\Program Files\Dbvisit\standbymp\bin>dbvcli.exe -d link csd
Connecting to the Control Center at SQLDR1:4433 ✓

Checking available actions for this configuration ✓

Full Backup Locations 1/2
Enter the directory to store the full backup on the source host.
Please ensure there is sufficient disk space in this directory to hold a full
backup of the source database.
Database size: 16.00 MB

Source Backup Directory:

> C:\Program Files\Dbvisit\standbymp\backup

Full Backup Locations 2/2
Enter the directory to store the full backup on the standby host.
Please ensure there is sufficient disk space in this directory to hold a full
backup of the source database.
Database size: 16.00 MB

Standby Backup Directory:

> C:\Program Files\Dbvisit\standbymp\backup

Database File Locations 1/2
Enter the location on the standby host for the database file 'link'.
Type: ROWS
Size: 8.00 MB
Location on source: C:\Program Files\Microsoft SQL
Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\link.mdf

Database File Location:

> C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\link.mdf

Database File Locations 2/2
Enter the location on the standby host for the database file 'link_log'.
Type: LOG
Size: 8.00 MB
Location on source: C:\Program Files\Microsoft SQL
Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\link_log.ldf

Database File Location:

> C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\link_log.ldf

Automated Standby Update 1/2
Select whether to enable Automated Standby Update. This will keep the standby
database up to date using log backups taken at a set interval.

Enable Automated Standby Update:

(•) Yes
( ) No

Automated Standby Update 2/2
Enter the Automated Standby Update interval in seconds.

Automated Standby Update Interval:

> 300

Observer
Select whether to enable the Observer. The Observer will watch your
Configuration, and notify you on the Dashboard in case any problems are detected
with your Disaster Recovery Configuration.

Enable Observer:

(•) Yes
( ) No

Confirmation
A full backup of the source database will be created, transferred to the standby
host, and used to create the standby database. Select Yes to proceed with
creating the standby database, or No to cancel the operation.

Create Standby Database:

(•) Yes
( ) No

2024-11-02 20:53:43
2024-11-02 20:53:43  Preparing to create standby database
2024-11-02 20:53:43  Disabling Observer
2024-11-02 20:53:43  done
2024-11-02 20:53:43  Disabling Automated Standby Update
2024-11-02 20:53:43  done
2024-11-02 20:53:43  Backing up primary database
2024-11-02 20:54:04  Sending backup to standby
2024-11-02 20:54:11  Deleting outdated backup file: C:\Program Files\Dbvisit\standbymp\backup\C1-link-f-0-48-0000000039000000352800001-0000000039000000353100001.bak
2024-11-02 20:54:05  Creating standby database from backup
2024-11-02 20:54:05  Restoring full backup from file(s): C:\Program Files\Dbvisit\standbymp\backup\C1-link-f-0-48-0000000039000000352800001-0000000039000000353100001.bak.
2024-11-02 20:54:07  done
2024-11-02 20:54:07  Deleting outdated backup file: C:\Program Files\Dbvisit\standbymp\backup\C1-link-f-0-48-0000000039000000352800001-0000000039000000353100001.bak
2024-11-02 20:54:07  Applying logs received while in Standby Mode because Automated Standby Update is enabled
2024-11-02 20:54:07  Applying DR configuration
2024-11-02 20:54:07  Applying Automated Standby Update settings
2024-11-02 20:54:07  done
2024-11-02 20:54:07  Automated Standby Update enabled.
2024-11-02 20:54:07  Applying Observer settings
2024-11-02 20:54:07  Observer enabled.
2024-11-02 20:54:07
Task succeeded

Ensure the source-backup-dir and standby-backup-dir locations has enough free space and always recommend to provide a custom location rather than using the default location.

We're here to help!

Comments