sync

dbvcli sync -d CONFIGURATION_NAME [--OPTIONS]

  --compress-backup            string    compress the initial backup sent to the
                                         standby (on, off)
                                         the instance's default will be used
                                         otherwise

--compress-backup option was added in 12.3

Synchronize databases using differential backup

Example

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

Checking available actions for this configuration ✓

Configuration link (SQLPROD1 -> SQLDR1)

┌───────────────┐┌───────────────┐
│               ││               │
│    Primary    ││    Standby    │
│               ││               │
│    ONLINE     ││   RESTORING   │
│               ││               │
└───────────────┘└───────────────┘

Confirmation
Select Yes to proceed with synchronizing the primary and standby databases, or
No to cancel the operation.

Confirm Sync:

(•) Yes
( ) No

2024-11-02 21:16:50
2024-11-02 21:16:50  Creating differential backup from primary database
2024-11-02 21:16:51  Sending backup to standby
2024-11-02 21:16:51  Deleting outdated backup file: c:\backup\C1-link-d-0-48-0000000039000000364700001-0000000039000000365000001.bak
2024-11-02 21:16:52  Restoring differential backup on standby database
2024-11-02 21:16:52  Restoring differential backup from file(s): c:\backup\C1-link-d-0-48-0000000039000000364700001-0000000039000000365000001.bak.
2024-11-02 21:16:53  done
2024-11-02 21:16:53  Deleting outdated backup file: c:\backup\C1-link-d-0-48-0000000039000000364700001-0000000039000000365000001.bak
2024-11-02 21:16:53  Applying logs received while in Standby Mode because Automated Standby Update is enabled
2024-11-02 21:16:53  SQL Server switch to read-only schedules was not enabled prior to task; leaving it disabled.
2024-11-02 21:16:53
Task succeeded

We're here to help!

Comments