Manage Microsoft SQL Server READ ONLY mode

Subcommands

start Switch database into READ ONLY mode
exit Switch database into RESTORING mode
enable-schedule-function Turn on scheduled READ ONLY mode
disable-schedule-function Turn off scheduled READ ONLY mode
list-schedules List READ ONLY mode schedules
create-schedule Create READ ONLY mode schedule
enable-schedule Enable/disable READ ONLY mode schedule
disable-schedule Enable/disable READ ONLY mode schedule
edit-schedule Edit READ ONLY mode schedule
remove-schedule Remove READ ONLY mode schedule

start

dbvcli read-only-mode start {-d|--name} CONFIGURATION_NAME [--OPTIONS]

Switch database into READ ONLY mode

Option	Type	Description

Option	Type	Description
`--standby-file-directory`	string	directory in which to create standby file

C:\Program Files\Dbvisit\standbymp\bin>dbvcli.exe -d mine read-only-mode start
Connecting to the Control Center at localhost:4433 ✓

Checking available actions for this configuration ✓

Checking available actions for this configuration ✓

Standby File Directory
Enter the directory in which to create the standby file. This file is used by
SQL Server when the database is switched into READ ONLY mode.

Standby File Directory:

> c:\backup\

2024-11-13 08:25:13
2024-11-13 08:25:13  Switching standby database to standby mode
2024-11-13 08:25:13
Task succeeded

exit

dbvcli read-only-mode exit {-d|--name} CONFIGURATION_NAME

Switch database into RESTORING mode

enable-schedule-function

Turn on scheduled READ ONLY mode

disable-schedule-function

Turn off scheduled READ ONLY mode

list-schedules

List READ ONLY mode schedules

create-schedule

Create READ ONLY mode schedule

Option	Type	Description

Option	Type	Description
`--standby-file-directory`	string	directory in which to create standby file
`--cron-expression`	string	cron expression specifying when to activate READ ONLY mode
`--duration`	number	duration of READ ONLY mode, in minutes
`--schedule-name`	string	name of schedule (optional)

enable-schedule

Enable/disable READ ONLY mode schedule

Option	Type	Description

Option	Type	Description
`--schedule-id`	string, required	READ ONLY mode schedule ID to enable/disable

disable-schedule

Enable/disable READ ONLY mode schedule

Option	Type	Description

Option	Type	Description
`--schedule-id`	string, required	READ ONLY mode schedule ID to enable/disable

edit-schedule

Edit READ ONLY mode schedule

Option	Type	Description

Option	Type	Description
`--schedule-id`	string, required	READ ONLY mode schedule ID to edit
`--cron-expression`	string	cron expression specifying when to activate READ ONLY mode
`--duration`	number	duration of READ ONLY mode, in minutes
`--schedule-name`	string	name of schedule (optional)

remove-schedule

Remove READ ONLY mode schedule

Option	Type	Description

Option	Type	Description
`--schedule-id`	string, required	READ ONLY mode schedule ID to remove