Set Online/Offline
Go Up to Available object actions by DBMS
The Set Database(s) Online/Offline dialog lets you disable your databases to prevent access, and enable your databases to grant access through the Datasource menu.
Platform Availability
Important Notes
For Sybase ASE, you can only set databases online.
To Set One or More Databases Online or Offline
- Initiate a Set Online/Offline action against one or more databases. For more information see Initiating an object operation.
- Use the following table as a guide to working through the panels of the Set Online/Offline dialog
| Step | Settings and tasks | |
|---|---|---|
|
Action options |
Set offline (SQL Server only) |
Set this to TRUE to set the database offline or set it to True to set the database online. |
|
Dependencies |
Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies. | |
|
Preview |
Displays the DDL that will execute the object action. For details, see Preview. | |
- 3. Click Execute. For information on the scheduling option, see Scheduling.