create-standby, csd 

Owned by Vijayganesh Sivaprakasam
Nov 20, 2024
3 min read
dbvcli create-standby {-d|--name} CONFIGURATION_NAME [--OPTIONS] dbvcli csd {-d|--name} CONFIGURATION_NAME [--OPTIONS]

Set up disaster recovery

Option

Type

Description

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

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.