Operations: Server: How to Enable or Disable a Database

To enable or disable a database, use the ToggleDatabasesStateOperation.

Syntax

public ToggleDatabasesStateOperation(string databaseName, bool disable)

public ToggleDatabasesStateOperation(string[] databaseNames, bool disable) 

Parameters
databaseName	string	Name of database to toggle state
disable	bool	True, if database should be disabled, False is database should be enabled

Return Value
Disabled	bool	If database was disabled
Name	string	Name of the database
Success	bool	If request succeed
Reason	string	The reason for success or failure.

Example I

// disable Northwind database
ToggleDatabasesStateOperation toggleOperation = 
  new ToggleDatabasesStateOperation("Northwind", 
      disable: true);
store.Maintenance.Server.Send(toggleOperation);

Example II

// enable Foo and Bar databases
ToggleDatabasesStateOperation toggleOperation = 
  new ToggleDatabasesStateOperation(new [] { "Foo", "Bar" }, 
      disable: false);
store.Maintenance.Server.Send(toggleOperation);